Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i am using aggr function to derive a sum but i need to slice the data into quarter where the subtotal should be average of 3 month attched hereiwth is the data for the same
Thanking You
Vinayagam
Ok, you want averages for horizontal total and sum for vertical total of AVGPO, right?
Then you need to use Dimensionality() and SecondaryDimensionality() to switch between different expressions on total cells.
See attached AVGPO2 expression.
Maybe like attached?
Thanks Sir
But if u c the total below the centre its is giving avg wherein i require the sum of average
Thanking You
Vinayagam
Ok, you want averages for horizontal total and sum for vertical total of AVGPO, right?
Then you need to use Dimensionality() and SecondaryDimensionality() to switch between different expressions on total cells.
See attached AVGPO2 expression.
Hi swuehl
Good one.
Exactly sir thank u
sir in the same line could we get the sum of the subtotal VERTICAL total of horizontal avg
If I've understood correctly, just change the order of dimensionality checks:
=if( SecondaryDimensionality()=0,
avg( aggr( SUM(PO)/ COUNT(DISTINCT(Date)), Centre, MONTHNAME)),
if( Dimensionality()=0,
sum( aggr( SUM(PO)/ COUNT(DISTINCT(Date)), Centre, MONTHNAME)),
SUM(PO)/ COUNT(DISTINCT(Date))
))