Pivot Table Accumulation

[#1]

Hi all,

I made a pivot table containing the dimensions:

Divisionname

PerformanceWeek

PerformanceWeekday

Expression

=SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total?{$< Year = {$(=max(Year))} >}Revenue))

Now I want it to show me like this

                                   mo          tu          wed     th     fr     sa     su

Division1    Week 1         20          10          10        20   20   10      10          100%

                         2                                                                                     100%

                         3                                                                                     100%

Division2    Week 1         20          10          10        20   20   10      10          100%

                         2                                                                                     100%

                         3                                                                                     100%

But it shows me like this:

                                   mo          tu       wed     th     fr     sa     su

Division1    Week 1         2          1          1        2      2      1      1               9%

                         2         3            4           1       1      1     2      2                14% 

                         3          4                                                                         etc

Division2    Week 1         2           1        1        2       2      1      1         

                         2                                                                                    

                         3                                                                                   

                                                                                                              100%

I hope it's clear and my guess I don't need to use the total formula in my expression.

kind regards

[jonathandienst · Accepted solution]

Hi

You need a qualified total, one of these:

SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total <DivisionName> {$< Year = {$(=max(Year))} >}Revenue))

or

SUM({$< Year = {$(=max(Year))} >}Revenue)/(sum(total <PerformanceWeek, PerformanceWeekday> {$< Year = {$(=max(Year))} >}Revenue))

HTH

Jonathan