Pivot table totals

[#1]

Hi All,

I have a dimension used to break my data in the pivot table.

For some of the breaks there is only one category is there a way to suppress creating a sub total for these?

The pivot looks like this:

category 1       xxx        £500
                      yyy        £200
                      zzz        £800

                     subtot    £1500

category 2        aaa         100

                      subtot     £100 - this is the subtotal I want to supress/hide

                       total     £1600

Many thanks,

Phil

[raghavsurya]

Hi Phil,

According to my understanding, there no way you can hide subtotals for one category while displaying the other in Pivot table.

Regards,

Raghav

[#3]

Hi Phil,

there is a way to do so:

       If(Dimensionality()=1 and NoOfRows()=1,'', Sum(Amount))

as example!

Please see QV help to read more about the used inter-record functions.

Good luck!

Rainer

[#4]

Hi Rainer,

Many thanks for that I'm giving it a go now

Phil

[#5]

Thanks Raghav, for having a look - hopefully the answer from Rainer will do the trick.

Phil