Hi,
I am new to pivot tables and have a quick question.
I have a set of data that is supplied by two different people. At them moment I got a grand total that comes up totaling the two sets of data.
What I am after is to have toe two sets of data visible along with the variance between the two.
I have worked out how to find the variance but I then lose the original quantities.
Is there a way around this?
Pivot Query.pdf
Thanks for your help in advance.
Bookmarks