Pivot table with sum TOTAL

[#1]

I need to use a Dynamic table with TOTAL, but this should add up all the columns and not redo the calculation based on the total.

tks

[sunny_talwar]

Try this:

If(SecondaryDimensionality() = 0, Sum(Aggr(Sum(Metric)/Sum(Denom), Period)), Sum(Metric)/Sum(Denom))

Update: My bad the dimension should be Period and not SECTION.

[sunny_talwar]

I think after testing it out, this is what you might need:

If(SecondaryDimensionality() = 0 and Dimensionality() = 1, Sum(Aggr(Sum(Metric)/Sum(Denom), Period, SECTION)), If(SecondaryDimensionality() = 0 and Dimensionality() = 0, Sum(Aggr(Sum(Metric)/Sum(Denom), Period)), Sum(Metric)/Sum(Denom)))

[antoniotiman]

Hi,

You can try

If(SecondaryDimensionality()=0,
RangeSum(First(Sum(Metric)/Sum(Denom),1,NoOfColumns())),
Sum(Metric)/Sum(Denom))

Regards,

Antonio

[#5]

It worked, tks.

but forgot to mention that the total of the top must also add up. As example.

Can you help me?

[sunny_talwar · Accepted solution]

That simplify things:

Sum(Aggr(Sum(Metric)/Sum(Denom), Period, SECTION))

[#7]

Perfect... thanks so much...