Thread: How to sort a PivotTable based on OLAP Cube by one of the data fi.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JM JM is offline
external usenet poster
  
Posts: 37
Default 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?
Reply With QuoteReply With Quote