Top 10 rows and total of top 10

[sonikajain]

Dear all,

I need to implement a straight table where the top 10 rows based upon a particular measure are to be displayed, and then the total of the top 10 rows  as the 11th row.

Please sugeest ways to implement this.

[sonikajain]

Please help me in getting the total of remaining rows(ALL OTHERS) and the total of ALL ROWS in the same chart.

As soon as I apply the aggr function, the ALL  OTHERS and ALL ROWS have disappeared from the chart even though I make them selected in the properties chackbox.

[SunilChauhan]

send attached sample

[sonikajain]

I am experiencing problem in opening the file ...can u please send the settings/code

[SunilChauhan]

total can be achieved by  converting pivot table into straight

then expression_>sum of rows-> again convert into pivot

hope this helps