Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pivot Report where the Totals not correct.
For example, for PTD Date 07/13/2020 we see for differnet names -Total Orders 13 and Total Orders 19, but in Totals we see '-' instead of 32. Can you please help- the report is attached.
can you try this
Count({<flag_cease_cancel_orders={0}>}DISTINCT DD_Solution_Leg_ID)
or
=sum(aggr(if(flag_cease_cancel_orders=0,Count(DISTINCT DD_Solution_Leg_ID)), Dimension1,Dimension2))
where Dimension1,Dimension2 are pivot table dimension, you need to include all dimensions of pivot table
What is the expressions used? May be in expression you have applied aggr function but did not apply relevant aggregation function on top of that.
This is the presentation tab. - attached
can you try this
Count({<flag_cease_cancel_orders={0}>}DISTINCT DD_Solution_Leg_ID)
or
=sum(aggr(if(flag_cease_cancel_orders=0,Count(DISTINCT DD_Solution_Leg_ID)), Dimension1,Dimension2))
where Dimension1,Dimension2 are pivot table dimension, you need to include all dimensions of pivot table