Bug in OWC11 - Wrong Totals

Calculated measure shows incorrect totals!!!
[Measures].[Quantity (All Category)] = ([Measures].[Qty], [Category].[All Category])
let's say there are 3 categories ([Category].[Cat1], [Category].[Cat2], [Category].[Cat3]) with [Measures].[Qty] = 20 each.
The 3 categories are shown on the columns in the owc 11 pivottable and the [Measures].[Quantity (All Category)] shown as 60 for each category. But when i filtered out one of the category. The remaining 2 categories' [Measures].[Quantity (All Category)] shows as 40!!
I did not have this problem with using Crystal Analysis v10.

I'm using Analysis Services 2000. Is there a bug with pivottable services/MSOLAP8.0 driver?
Timmy

Here's my response to this question in the OLAP newgroup:

http://groups.google.com/group/microsoft.public.sqlserver.olap/msg/4b799055ad497b73

>>

This may be related to the "Visual Totals Mode" used by Excel and OWC, as explained in this past post:

http://groups.google.com/group/microsoft.public.sqlserver.olap/msg/fe7f645622c760b0

>>

From: Chris Webb
Date: Tues, Apr 19 2005 3:41 am

Well, I think the best place to start is probably the section on
VisualTotals
in this white paper:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anserd...
What the paper calls 'Visual Totals Mode' is switched on by using the
'Default MDX Visual Mode' connection string property, and this is what
Excel
uses to calculate its subtotals. So once you know that the subtotals are
really just parent members with their values overwritten, it's clear
that
calculated measures are going to be evaluated after this has taken place
and
so aren't going to be affected - and that's why, to get the behaviour
needed
in this case, it was necessary to create a real measure and get the
desired
values into it somehow.
>>

To see the VisualTotals() effect in AS 2000, try this Foodmart query in
the MDX Sample app:

With Member [Measures].[Sales (All Category)] as
'([Measures].[Unit Sales], [Product].[All Products])'

select {[Measures].[Unit Sales], [Measures].[Sales (All Category)]} on 0,
VisualTotals(Except(DrillDownLevel({[Product].[All Products]}),
{[Product].[All Products].[Drink]})) on 1
from Sales

>>