erasing rows in a table chart

[#1]

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...

[eddysanchez]

In the chart is impossible because have advanced logic

In your script, you need to do a pivot table and with a resident load delete those negative values