Pivot table (Set analysis) with drill down group

madhubabum — Wed, 26 Aug 2015 10:59:44 GMT

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

Re: Pivot table (Set analysis) with drill down group

madhubabum — Wed, 26 Aug 2015 13:07:24 GMT

hi gysbert wassenaar‌;

Please provide to me a solution.

it is much needed for me

Thanks

madhu