J
Jim W
I have a large file which I have simplified below:
acct name actual budget variance
3010 soda sales 200 150 50
6010 soda exp 125 100 25
I am trying to create a pivot table that would enable me to select certain
account numbers and see the actual budget and variance columns of data...I
want to be able to select 3010 and see the name the actual, buget and
variance. I can create a pivot table and get actual OR budget OR variance to
appear in the data field but cannot get all 3 to appear. Most samples I have
seen are only working with pulling one column of data.
acct name actual budget variance
3010 soda sales 200 150 50
6010 soda exp 125 100 25
I am trying to create a pivot table that would enable me to select certain
account numbers and see the actual budget and variance columns of data...I
want to be able to select 3010 and see the name the actual, buget and
variance. I can create a pivot table and get actual OR budget OR variance to
appear in the data field but cannot get all 3 to appear. Most samples I have
seen are only working with pulling one column of data.