Trying to create a pivot table with 3 functions: Quarter, Competitor and Segment.
Trying to display data as Segment>Competitor Quarter Wise.
Expressions: Total Sales, Market Share.
The table is not showing values as per different segment. Its showing the total amount. What formula should i use that the values are shown as per segments.
Have you used partial sums options in the Chart properties? Once enabled this options will show you the segment wise sum when you expand the Pivot table nodes.
