Additional Row(s) To Total Row

[Anonymous]

Is it possible to create a row in addition to Total row. For example, if I have a straight chart that has Top 10 of Clients's Sales, and I wanted to show "Top 10 as % of Total" after the Total row whose expression or formula is:

Sum of Top 10 Clients / Sum of Total * 100

Thank you for any suggestions.

[#2]

Try this in a text box:

Num(SUM({<Client = {"=RANK(AGGR(SUM(Sales),Client))<=10"}>} Sales)/Sum(TOTAL Sales),'###,###.##%')

[Anonymous]

Thanks Rebecca,
I'm trying to implement this in the same chart where I show the Total.