Grouping fields of one dimension

[absekrafi]

I wasn't able to attach this image to the previous discussion, so I created a new one.

[sunny_talwar]

What exactly are you trying to group into one dimension? How should the above table look like?

[absekrafi]

Lest say, I sell my product to Europe, North America and Asia .

In my pivot table I have the total of quantity sold to each continent by selecting the date interval.

Know I want to get the total of all quantity sold in the world, by my company.

For example my company name is COMPANY. I want to see the total of sold quantity in Europe, North america and Asia. When I expand it, I see the quantity sold in each continent.

[absekrafi · Accepted solution]

Hi Sunny,

I found a solution to what I want.

I cheched sub-totals, in pivot table, and I added :

=if(GetSelectedCount(REGION)=0, 'Total GCT', 'Total '&REGION) in the label.

It's working.

Thank you