pivot table partial sum label based on parent hierarchy
Hi,
I have 2 dimensions in pivot table:
marketname and division which comes under marketname.
1 expression which is sum of employee flag.
market name has 2 values : northeast and southeast.
in total of marketname column; i labelled as total premier.this is fine. But under total of division names column; it is showing total but i want marketname under which the division comes have to be displayed.