Display Totals as Row Headings

T

Trevor

I am using OWC 10 to create views of my cube and am using
the DOM to programatically set the default view that I
want the users to see.

I have searched the documentation extensively and have not
found a way to programatically do the equivanent of
Displaying Totals as Row Headings using the DOM. The
manual way is to select the Commands and Options, then the
Report Tab and then select the Display Totals as Row
Headings option.

Can anybody help?
 
D

Dan Ricker

PivotTable1.ActiveView.TotalOrientation =
PivotTable1.Constants.plTotalOrientationRow

and back

PivotTable1.ActiveView.TotalOrientation =
PivotTable1.Constants.plTotalOrientationColumn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to manipulate such Microsoft PowerPoint pop-ups as Font from the keyboard? 1
Object Browser in VBA 0
ROW NUMBER IN OWC10 PIVOT 0
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
How do I set focus (and select text) on a text box on a modeless userform? 0
to display specific group by result in Crosstab query 13
drillthrough hyperlink columns 4
filter result- total row numbers varies 1

Top