I have a report table with 30 rows . I add Rank([Revenue];[Product]) in this table, and then add a filter Rank([Revenue];[Product])<=10 . As a result ,the table only show top 10 records. very well.
Now I want the pie chart to show the top 10 records, What can I do for this?
garyych (BOB member since 2010-04-26)
Hi,
For the same it is posible to get the count of (([Revenue];[Product])<=10 )
out of 30 rows,there are 9 rows with value>10 then i need to get the count has 9.
deadly782 (BOB member since 2008-12-08)
Create a variable as V_Rank for Rank and add it in your report
then apply Rank for top 10 results then convert it to Pie chart.
Rajubollas 
(BOB member since 2009-09-04)
Hi Rajubollas,
It doesn’t work.
I have add a varible [Top 10]. I drag it to the table, it works,show the top 10. But WHen drag the [product] to the pie chart dimension area with statement ‘[product]where([Top 10]<=10)’ and [revenue] to the measure area, It doesn’t work.
garyych (BOB member since 2010-04-26)
I’m not sure if you figured this out, but I had the same issue, here’s how I fixed it.
I took the exact same filter I used for the Table (Rank <10) and applied it to the Pie Chart. Just click the Pie chart and then open the filter and it worked fine.
abouelse (BOB member since 2010-02-01)
I don’t understand all this exercise, why don’t you include product, revenue in your chart and then select revenue from pie chart in structure mode, and apply top 10 ranking, it should work.
Prashant Purohit (BOB member since 2009-02-18)