-
1. Re: Strange,Unable to filter TOP 10 dimension based on measure.
Ranjan Sahoo Apr 11, 2012 4:05 AM (in response to Ranjan Sahoo)Hi,
I finally managed to do the same counting intiative name in running count and selecting only 10 as running count.
But i need to do the samething in the chart also in the sheet no. 21 and sheet no. 24 of the attachment that i have done earlier.
I can't do running count as the dim. is not there, but still i need to take only top 10 data.
Top 10 data not of table but of the data that is available with the report or the data that is present inside the chart or query.
Thanks,
Ranjan
-
2. Re: Strange,Unable to filter TOP 10 dimension based on measure.
Tracy RodgersApr 11, 2012 9:18 AM (in response to Ranjan Sahoo)
Hi Ranjan,
On Sheet26, you can find the top ten by using the index function. Sort the Initiative Name in the desired order (which I believe is already done). Then, create a calculated field similar to the following:
index()<=10
Place this calculation on the filter shelf and select True. Hope this helps!
-Tracy
-
3. Re: Strange,Unable to filter TOP 10 dimension based on measure.
Ranjan Sahoo Apr 11, 2012 9:24 AM (in response to Tracy Rodgers)Thank you Tracy, a great help.
I was doing differently, but your answer-simple and great.
Thanks,
Ranjan