Calculating Total in Pivot Table With Drill Down Group

[madhubabum]

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

[gautik92]

attach the sample qvw file

[madhubabum]

Hi Gowtham

Have you got any idea ?

[jonathandienst]

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.