Hiding subtotals, showing grand totals w/PivotTable

[Tony Bull]

Greetings all,

I created a cube based on a join between two views: the first view tracks
inventory movement for some products, the second gives the number in stock
for those products. It was a bad design decision at the time, I'll admit,
but that's water under the bridge (that is, if I can come up with a
work-around to the problem I'm posing to you all...)

So, the join results in something like this:

ProductName Month Qty InStock
-----------------------------------------------------------
Beads Dec 20 14
Beads Apr 5 14
Carpets Dec 40 100
Carpets Feb 30 100
Carpets June 10 100

.... where InStock is the current number of whichever product it is that's in
stock. Before, I was getting reports from the Cube that looked like this:

**** InStock****
Month Dec Feb Apr June TOTALS
--------------------------------------------------------
Beads 14 14 28
Carpets 100 100 100 300

...which of course wasn't right, so I divided the TOTAL by the number of
occurances of InStock so that now I get something like this:

**** InStock****
Month Dec Feb Apr June TOTALS
--------------------------------------------------------
Beads 7 7 14
Carpets 33.3 33.3 33.3 100

But that only makes sense because the TOTALS are right. That there's a
value of 7 in Dec and Apr for Beads is nonsense, but the TOTAL is right.

So, the question: how can I hide the measure values in a cube and only
display the grand totals?

Thanks a million!