My client wishes to have two pivot tables, one showing positive results and the other showing negative results.
BUSINESS A 1000
BUSINESS B 500
BUSINESS C 100
BUSINESS A -1000
BUSINESS B -500
BUSINESS C -100
Is it possible to then select the different DIMENSION with one select column for both?
Not sure I got it right try this
for Number column pull twice and set col*-1
use 2 pivot table for each number type
cool as ~ http://cool-bi.com