Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
how can i do this...
Thanks...
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