Excel spreadsheet
I did that.
Here is an example of my report:
Attr - Brand Level Dollar Sales Unit Sales Rank
COLGATE 360 $37,008,315 8,966,184 1
ORAL B INDICATOR $29,493,049 10,599,211 2
ORAL B ADVTG. PLUS $28,970,590 7,438,801 3
I'd like to add the % change in Dollar & Units for each.
In the pivot table I added the Brand Level, Dollar Sales and Unit Sales.
Would that be correct?
What is my next step?
Thank you
"Eduardo" wrote:
Hi,
Add two columns in your spreadsheet with those calculations and add them
into the PV,
"BGuzman" wrote:
Hello, I need help.
I made a pivot table for a report based on brand totals , i wish to add the
% change in Dollar & Units for each. ... How do i do that?
Please help.
|