Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached example. I've added the total columns as calculated dimensions.
See attached example. I've added the total columns as calculated dimensions.
Thanks !! I'm sorry for my late answer; it's what I exaclty needed
Stefan