Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the table below. I want to create different calculations based on the dimension in the Pivot Table.
For example, the top row, POV is calculated with count(level1_order). I want the POV and VWAP below the top POV row (marked in red) to be calculated with count(level2_order)?
How can I do this?
Use Dimensionality()
If(Dimensionality()=1,Count(Level1),Count(Level2)) or whatever else you need (you can also use Pick() with your Dimensionality if relevant)
Use Dimensionality()
If(Dimensionality()=1,Count(Level1),Count(Level2)) or whatever else you need (you can also use Pick() with your Dimensionality if relevant)