I am confused/frustrated by Excel's behaviour using the following simple calculated measure.:-

([Measures].[Sales] , [Product].[All Products])

When this measure is used in an Excel pivot, which shows a subset of products selected, the measure returns a sum f the visible products, NOT the total [All Product]. Is Excel (PTS) secretly using the VisualTotals function in its MDX? The MDX I extracted from the pivot table does not appear to be using the VisualTotals function.

Is there anyway to work around this behaviour?

LookupCube function

"Rob D" <Rob D (AT) discussions (DOT) microsoft.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:FF2EAD4E-D6A7-4E89-8BD9-0CFAE39D0B8B (AT) microsoft (DOT) com...
total [All Product]. Is Excel (PTS) secretly using the VisualTotals function
in its MDX? The MDX I extracted from the pivot table does not appear to be
using the VisualTotals function.