Pivot Table Pushing Grand Totals to the Far Left of Pivot

[nlemieux1978]

Hi There I have a Pivot where in the "Columns" Strategic Region as 3 Regions (Emerging, Europe, North America). There are 2 attributes I want to bring data in under "Values (Sales Amount T1 LY and Sales Amount T1 YOY). As you can see the pivot is pushing the Grand Totals for the 2 attributes to the far right. How can have the Totals in the right spot before or after the (Emerging, Europe, North America) groupings. The data is coming in from a Data Model.

 

[nlemieux1978]

Hi There I have a Pivot where in the "Columns" Strategic Region as 3 Regions (Emerging, Europe, North America). There are 2 attributes I want to bring data in under "Values (Sales Amount T1 LY and Sales Amount T1 YOY). As you can see the pivot is pushing the Grand Totals for the 2 attributes to the far right. How can have the Totals in the right spot before or after the (Emerging, Europe, North America) groupings. The data is coming in from a Data Model.

Sorry I meant toi Far right of Pivot