Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I am Using Pivot Table with Drill Down Group as ::::Region > District > Client > Profit Center (4 Dimensions)
Note : Partial Sum (Enabled)
If i am Click on region level (Showing Totals as Errors) , same as District , Client , Profit Center
I am attaching the Screen shots as attached document
So,How can i resolve the Problem ?
Thanks
Madhu
attach the sample qvw file
Hi Gowtham
Have you got any idea ?
Your Total Equipment expression needs to include the table dimensions in the Aggr expression. You can do this:
sum(Aggr(Count(EquipmentModelName),
EquipmentGroupName,EquipmentClassName,
EquipmentCategoryName,EquipmentModelName,
$(=GetCurrentField(<your group name here>))
))
Insert your correct group name into the above expression where indicated.