Totals in Pivot Tables

[Flybridge]

(I have posted this on the MS Office section but didn't get the reply I need, so perhaps this is the better place to put this question.)

I have an OLAP cube created in MS OLAP that I am presenting via a pivot table in Excel 2003. I can't get column totals to appear (but can get row totals). When I pivot the data I get column totals but not row totals.

What is causing this restriction? If I query the data warehouse source directly and report back as a pivot table I get the totals, so why not when I report out of the cube?

40 million lemmings can't be wrong........can they?

 

[Flybridge]

I've just noticed something.

The cube is a financial data cube and there are a number of dimensions to the account number. If I show dimension 1 as the outside dimension I get totals per account. But if I show dimension 2 as the outside dimension I don't get department totals.(Which is what I want)

I don't know if this helps someone figure out what is happening - I hope it does coz it's driving me nuts.

Flybridge

40 million lemmings can't be wrong........can they?