Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Facing challenge with delete columns with null values in Pivot group if its grouped under one label. Have dimension as units, two more dimensions for Period (MTD,QTD,Value) and Flows (Inflows, outflows) as inline table. Measures as Flows, Revenue. In some cases measure column is blank and we don't need them. Even though measure for blank columns are not added it is still showing as '-'.
so Pivot table looks like this :
Units Aum
Inflows
Flows Revenue
Appreciate any help.
not completly clear on the challenge. share a sample app if you can