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.
