View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BGuzman BGuzman is offline
external usenet poster
 
Posts: 2
Default 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.