Hiding rows in table

[#1]

Hi,

I've got a problem in a pivot Table with products, months and sum sales. I need a additional column with the sales per jear for each month.

So far so good thats easy with set analysis: sum( {$<Monat_OrderDate=>} total<Product> Sales)

But when I select some months in the list box. I want to see only those lines with sum(sales) > 0.

How can I do this?

Have Fun With QV

Alex:)

[#2 · Accepted solution]

Modify the formula e.g. like this:

IF([Sum(Sales)]>0, sum( {$<Monat_OrderDate=>} total<Product> Sales))

Kind regards.

[#3]

Thaks a lot,

I had a mental block!

Have Fun With QV

Alex #-)