How to sort a PivotTable based on OLAP Cube by one of the data fi.

J

JM

My PivotTable is based on an OLAP Cube.
I need to sort the PivotTable by a data field, but get only VB errors.
i.e. I have "Slesperson" in rows, "Q1 . . .Q4" in columns, "Sales Amount" as
data field.
I want to sort by Q1 Sales Amount.
Can anyone help?
 

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

No Baseline data in OLAP CUBE 0
No Baseline data in Olap Cube 0
Creating a Chart on form from selected data in query. 0
OLAP – returning data from a separate list 1
Newbie OLAP pivottable filter and sort on values 0
Link a text box based on drop down box with four options MS Word 365 0
Summarise data by average in OLAP cube 2
PivotTable filter ordering 0

Top