Sum/Total excluding certain items

[#1]

Hi there,

I'm looking for a way to exclude certain rows from the total of pivot table:

Let's assume I had a table like that

PRODUCT
A 10
B 20
C 50
TOTAL 80

And I would like to display the table like it is but exclude B from the total, so that the total shows as 60 while all the details for A, B and C show.
Not displaying B is not an option, also because I have three fact dimensions and a time dimension I cannot switch to a straight table.

Thanks for your help!

Cheers, Lukas

[lironbaram · Accepted solution]

hi

as there is aproblem in the site and i cant attach a file,

you can cotrol the sub totals by using dimensionality

this is a link to a file with example

https://download.yousendit.com/VGljZUNpTk1ENlEwTVE9PQ

hope it will help you

[#3]

Thanks, you've saved my day, it works perfectly well!

Have a nice day

Lukas