1 Reply Latest reply: Apr 1, 2013 1:42 PM by Eddy Sanchez RSS

    erasing rows in a table chart

      hello,

       

      i have a pivot table with  documents as dimension and a sum expression.

       

      something like this...

      Document          Value

          vc-1               100

          vc-2               50

           vc-3              -100

      total                   50

       

      i need to do in the chart if any document have the same value in negative of other erase the two of them...

       

      and the table looks something like...

       

      Document          Value

          vc-2               50

      total                   50

       

       

      how can i do this...

       

       

      Thanks...