Calculated Totals & Position

[Chris Magoun]

Greetings,

I have a pivot table connected to a cube. A list of hospitals in on my row
axis, and a set of dates (expanded by quarter) is on the column axis. I am
programmatically adding a calculated total called slope. However, each
quarter then gets a column called slope. I would like slope to appear in the
same section as the grand totals.

So I get:

Q1 Slope Q2 Slope Q3 Slope Grand Total

Hosp 1
Hosp 2
Hosp 3

I would like:

Q1 Q2 Q3 Slope Grand Total

Hosp 1
Hosp 2
Hosp 3

Thank you,
Chris Magoun