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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to sort a PivotTable based on OLAP Cube by one of the data fi. (https://www.excelbanter.com/excel-programming/323282-how-sort-pivottable-based-olap-cube-one-data-fi.html)

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

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?

All times are GMT +1. The time now is 09:18 PM.