Hi,

We are trying to make analysis using Excel 2003 Pivot table using an OLAP
cube as external data source.
Within the cube, we have a calculated member, taking "Distinct Count" of a
dimension member.

Our problem is that, for the data fields within the pivot table at the
excel, calculated member works fine, but for the grand totals, calculated
member shows unexpected results.
Therefore we can' t use such analysis like "% of column" and so on.

Can u advise a method to solve this problem or reason for this situation.

Thanks.
Orhan