Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I check why the numbers increase from a pivot table
I creat a pivot table from my data, after I see the report in the pivot table
now I have to do a reverse look up on how or why the nubers increase from last week reports. I try every thing and I do not know how to get the answer for my reports. If any one know how to do this please I need your help on this Thank You |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I check why the numbers increase from a pivot table
Stacey,
You would need to have a date for each data point, and then you could group the data by date, or use the date as a page field. Failing that, you would need to store a copy of the pivot table as values, and use it to compare to the current pivot table. HTH, Bernie MS Excel MVP "Stacey" wrote in message ... I creat a pivot table from my data, after I see the report in the pivot table now I have to do a reverse look up on how or why the nubers increase from last week reports. I try every thing and I do not know how to get the answer for my reports. If any one know how to do this please I need your help on this Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
How to increase calculations speed in pivot table with calculated fields & items | Excel Discussion (Misc queries) | |||
Keeping Column Widths the same in a pivot table when pages increase | Excel Discussion (Misc queries) | |||
How to increase the size of a Pivot Table Graph | Excel Discussion (Misc queries) |