sophea_tum
New Member
- Joined
- May 8, 2015
- Messages
- 42
Hi all,
I am new in the power pivot when i matching with 2 table in the power pivot and make it in pivot in excel then the grand total is correct but wen I make the filter in the pivot the grand total still remind the same. please help.
there is the example that show in the Pivot.
Before filter:
Group.......Items......QTY
A..............A1............1
A..............A2............6
Subtotal A................7
B..............B1............3
B..............B2............6
B..............B3............1
SubTotal B..............10
Grand Total............17
After filter:
Group.(A)...Items......QTY
A................A1............1
A................A2............6
Subtotal A..................7
Grand Total..............17
After filter the grand total should be 7 not 17.
Please Help!
I am new in the power pivot when i matching with 2 table in the power pivot and make it in pivot in excel then the grand total is correct but wen I make the filter in the pivot the grand total still remind the same. please help.
there is the example that show in the Pivot.
Before filter:
Group.......Items......QTY
A..............A1............1
A..............A2............6
Subtotal A................7
B..............B1............3
B..............B2............6
B..............B3............1
SubTotal B..............10
Grand Total............17
After filter:
Group.(A)...Items......QTY
A................A1............1
A................A2............6
Subtotal A..................7
Grand Total..............17
After filter the grand total should be 7 not 17.
Please Help!
