topcount function chart

[Windelen]

Hello,

I hope you guys can help me out here. I'have a data drop down with 'countries' that is connected with
a datadeck. In this datadeck I have placed a pie chart. For the slices of this pie, I have placed all months of the year 2011. the pie chart shows for each month the 'sold volumn'.
But now I want to just see the top 5 months, based on the 'sold volum'.  Could someone explain me in some steps what to do?

big thanks.

[MFGF]

Hi,

Is this based on a dimensional package? If so, then instead of bringing in the 12 month members for 2011, you could bring in a query calculation that uses the topCount() function to derive your top 5 months based on your measure.

If it's a relational package, you will probably need to add a rank calculation based on month, then filter on rank being between 1 and 5.

Cheers!

MF.

[Windelen]

Yep figured it out eventually.
THX MFGF

closing topic...