Sub Total of 2 dimensions

[gbechard]

Hello

I built a pivot table with 2 dimensions on rows (Region and Sales Rep).

3 Expressions in columns.

I'm trying to have on top rows the aggregation of 2 dimensions (Since Sales rep work on all regions).

Could someone tell me if it's possible to do as in this picture ?

See below, what I have is only one line of total on the first dimension. So no way to see the total per sales rep in the same table...unless someone can help

Thanks for your help

G

[sunny_talwar]

Would you be able to share your app to play around with?

[#3]

Could you please share some sample data

[gbechard]

Sure

Hope this will help

Thanks a lot

[Anil_Babu_Samineni]

I don't think there is another approach to do this. I know i did follow the stupid Approach. But, Interesting

[gbechard]

Thanks for your answer Anil

I hope there is an other way, since in my live application, the crosstable control is in a Tab control which makes the overlap not really convenient

[Anil_Babu_Samineni]

Let's try from my end. If i came to know any address i may connect you again. Interesting

[gbechard]

I cross my fingers

Thanks Anil

[sunny_talwar · Accepted solution]

May be something along these lines

[gbechard]

Thanks sunny, it seems a very  good option.

Could you give me a quick explanation of the logic (use of Dim), and also why you typed "Only({1}Dim)" in the sorting part. I did not get it from the documentation.

Thanks again