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.
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.
Yep figured it out eventually.
THX MFGF
closing topic...