Hi!

When I create a pivot table report from OLAP source and then filter some
data I get totals including the hidden fields. How could I display the
totals of only filterd fields and not all? I notices that this works in
Excel 2003, but one of our clients is using excel 2000 and the only thing I
got is to export it to web component and then there turn of the totals of
all field.

Tnx in advance

You can edit your .htm page using MSFrontpage. Then you can modify the
properties of the PivotList and save the page again.


"Grega Jerkic" <grega.jerkic (AT) siol (DOT) net> wrote

But the main question is can it be done in excel, so that i get the real
sums (without hidden members)?

"Francesco Anti" <fanti (AT) sicosbt (DOT) it> wrote

No, not that I'm aware of.

You may consider adding the selections frequently used as levels or
calculated members (customer member formula) to your dimensions.

e.g.

Let's say you have a time dimension like this:
Levels:
-Year
-Month
-2004
-2004/01
-2004/02
-2004/03
-2004/04

....


If your end users often require to filter a quarter add a quarter
level

-2004
-2004/Q1
-2004/01
...
-2004/Q2

or if you don't want to add a level add calculated members (half year
for instance)


-2004
-2004/Q1
-2004/01
...
-2004/Q2
...
-2004/Q3
...
-2004/Q4
...
-2004/H1 custom formula: [Time].[2004/Q1]+[Time].[2004/Q2]


Besides that, if possible have your client upgrade to Excel XP (2002)
or above. It's much better with pivots based on OLAP cubes not only in
regards to visual totals.



"Grega Jerkic" <grega.jerkic (AT) siol (DOT) net> wrote