Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using 2 pivot tables :
Pivot table 1: Using Region (Drill down Dimension) &
Expression :
count( aggr(Count(EquipmentId),EquipmentGroupName,EquipmentClassName,EquipmentModelName))
Pivot table 2: Using Group (Drill down dimension) & Expression : Count(DISTINCT EquipmentId)
Note : If i select "region" filter on multi box , The values are not matching on both pivot tables..
(Totals are not matching on bellow Pivot two tables)
So, How can i rectify this one ?
Any One Have any Idea ?
Thanks
madhu
hi gysbert wassenaar;
Please provide to me a solution.
it is much needed for me
Thanks
madhu