Grouping fields of one dimension

[absekrafi]

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

[MK9885]

could you please explain more?

[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.

[achettipalli]

You have different presentation options:

1.Can add the Company dimension before the Continent field in the pivot table.

2. Add a List box filter of company field.

3. Create set analysis of company field in the expression field like Count({<Company = {'Company'}>}sales)

Good luck!

[absekrafi · Accepted solution]

Hi Avinash,

I found a solution to what I want.

I cheched sub-totals and I added :

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

It's working.

Thank you