Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That simplify things:
Sum(Aggr(Sum(Metric)/Sum(Denom), Period, SECTION))
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.
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)))
Hi,
You can try
If(SecondaryDimensionality()=0,
RangeSum(First(Sum(Metric)/Sum(Denom),1,NoOfColumns())),
Sum(Metric)/Sum(Denom))
Regards,
Antonio
It worked, tks.
but forgot to mention that the total of the top must also add up. As example.
Can you help me?
That simplify things:
Sum(Aggr(Sum(Metric)/Sum(Denom), Period, SECTION))
Perfect... thanks so much...