pivot table data


K

KrispyData

Hi. I have 2 pivot tables using the same source data (a datasheet within the
workbook). For one of the pivot tables, I want to show the data by month.
For the second pivot table, i want to show the data by quarters. So, for the
second pivot table, i group the month fields. However, this grouping somehow
affects the first pivot table and this table now shows quarters instead of
the individual months that i want. How can group the fields of one pivot
table without affecting the other pivot table?

Thanks!
 
Ad

Advertisements

T

trip_to_tokyo

Hi KrispyData!

Check out:-

http://www.pierrefondes.com/

- at the top of the home page (item number 22).

It is a simple example based upon what you have said (in EXCEL 2007) and
seems to give you what you want. Let me know if it doesn't.
 
Ad

Advertisements

H

Hamish Graham

Hi,

I also had this problem. Apparently it is the way Excel caches the dataset (http://books.google.co.nz/books?id=...ping affects other pivot tables excel&f=false)

Instead of going through the process of that link though, I simply changed the number of rows that my separate pivot tables were looking at in the dataset... it seems to have a separate cache for each in that case. i.e for one I had including up to row 1000 and the other 1001. Seemed to work (empty row which can be excluded in a pivot table filter)



KrispyData wrote:

pivot table data
01-Dec-09

Hi. I have 2 pivot tables using the same source data (a datasheet within the
workbook). For one of the pivot tables, I want to show the data by month.
For the second pivot table, i want to show the data by quarters. So, for the
second pivot table, i group the month fields. However, this grouping somehow
affects the first pivot table and this table now shows quarters instead of
the individual months that i want. How can group the fields of one pivot
table without affecting the other pivot table?

Thanks!

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Fast KeyWord String searching Algorithms
http://www.eggheadcafe.com/tutorial...3-4decf97d75ce/fast-keyword-string-searc.aspx
 

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

Top