2 Replies Latest reply: Dec 2, 2009 12:10 PM by alexander.schubert RSS

    Hiding rows in table

      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:)