Pivot table problem

G

George

Dear friends,

I have a list in an Excel 2007 spreadsheet:

Column A: Month (eg.Jan. 2007, Feb. 2007, Jan. 2008, Feb. 2008 – actually is
a date field and formatted to show only Month and Year)

ColumnB: Quantity (of sold products, eg. 2059, 1507, 2770, 1996 etc)
I have already inserted a pivot table which shows in first column the Month,
and then following columns are the years, e.g. 2007, 2008 and under each year
shows a value-quantity, using the Running totals. This works fine.

I want now to create another pivot table in order to show me the running
difference % between years/months e.g. using the above example to show me:

1. Percent difference between Jan. 2007 and Jan. 2008
2. Percent difference between Feb. 2008 and Feb. 2008 – Both using the
running totals

Any help will be highly appreciated,

Thanking you in advance

GeorgeCY
 
G

George

Thank you, but unfortunately I can`t open the PDF (is damaged as it says)
and the first downloads a zip file containing a lot of xml files - How can I
open those - in Excel probably?

Thanks again,

George

Ο χÏήστης "Herbert Seidenberg" έγγÏαψε:
 
G

George

Thanks again,

xlsx file downloaded OK.

Unfortunately no luck with the PDF - Is these some notes of how to carry out
the wanted task? - I would appreciated very much (if these are notes about
the xlsx file), if possible to send it to me by email?
[email protected]
(remove all 1 to contact me)

Thanking you so much again,

George


Ο χÏήστης "Herbert Seidenberg" έγγÏαψε:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table and Grouping Problem 3
Information for Pivot Table 3
Pivot table - Problem with % 5
Pivot table - Problem with % - part 2 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table - Show difference 6
Grand Total for Rows not Working in a Pivot Table 1
Countif or sumif for cumulative sums,pivot table & chart 2

Top