Alex Krea Mas
New Member
- Joined
- Feb 15, 2014
- Messages
- 1
Hello guys
I've created a Pivot Table using Excel 2010. My data comes from a sales databases so what I needed is to get the market share obtained from actual year (i.e. December 2013) and last year (i.e. December 2012).
It was easily done by displaying the data as % of Column Total, but my issue is that I need to calculate the difference between both columns of market share. I've tried doing that just by taking the difference using Calculated Field, i.e. "M.S. DEC. 13" - "M.S. DEC. 12" but the result comes from the data in Absolute, I mean, as if I haven't applied % of Column Total.
Is there any solution to this issue?, How can I use the percentages obtained from % of Column Total?
I've created a Pivot Table using Excel 2010. My data comes from a sales databases so what I needed is to get the market share obtained from actual year (i.e. December 2013) and last year (i.e. December 2012).
It was easily done by displaying the data as % of Column Total, but my issue is that I need to calculate the difference between both columns of market share. I've tried doing that just by taking the difference using Calculated Field, i.e. "M.S. DEC. 13" - "M.S. DEC. 12" but the result comes from the data in Absolute, I mean, as if I haven't applied % of Column Total.
Is there any solution to this issue?, How can I use the percentages obtained from % of Column Total?
