Dear All,

I'm new to OLAP and would like some help in OLAP.

I have a calculated member 'A' with the following formula:
B/C=A

Therefore in Pivot Table:
B|C|A
100|5|20
100|10|10
Total is 200|15|13.33

However, the correct total for A is 30, not 13.33 (200/15) as
calculated above.

I know that I can use solve order function by setting higher solve
order for 'Total' column and lower solve order for 'A' column.

But the 'Total' column here is derived from the Pivot Table and not a
column that I defined in OLAP. My question is: how do I apply the solve
order to the 'Total' in the Pivot Table so that it will give me the
correct calculation?


Thanks in advance
Josephine