Pivot table

[Anonymous]

Dear all,

I'm a bit confused. I have a pivot table like this:

Customer      Country A          Country B                        .....           Last Country

AAA               1000                      500                            ....                100

BBB               2000                      1000                            .....               50

As dimension I considered the Customers and Country codes

As expressions I considered sum(turnover)

Now I would add a Total Column for each Customer and I would display the percentage for each country, like this:

Customer      TOTAL          Country A   %        Country B    %                 .....           Last Country    %

AAA              10000                   1000   10           500           5                 ....              100                1   

BBB              4000                     2000   50           1000        25                .....               50                1,25   

The percentage value, is calculated by the  CountryATurnover/TOTAL turnover

How can I realize this kind of pivot table ?

Thanks in advance for your help, I need it

[Gysbert_Wassenaar · Accepted solution]

See attached example. I've added the total columns as calculated dimensions.

[Anonymous]

Thanks !! I'm sorry for my late answer; it's what I exaclty needed

Stefan