2 Replies Latest reply: Oct 19, 2012 9:34 AM by steve peroni RSS

    Pivot table

    steve peroni

      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