Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table/ % Change
The 'Show Data As' option will only work if "This Year" and "Last Year"
are items in the same fields. If not, you would use a calculated field to calculate the difference. Datasort wrote: Is there a way to have a percent change field calculated in a pivot table with out building a custom formula? I have looked in the field settings under the show data as and I am not about to determine the selections. Specifically, the Show Data AS, Base Field, Base Item I have 2 fields: LastYear and ThisYear I am trying to get (thisYear-LastYear)/Thisyear Thanks in advance, Stewart Rogers -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing for every change in a pivot table | Excel Discussion (Misc queries) | |||
How to change the precision for Pivot Table | Excel Discussion (Misc queries) | |||
can i change pivot table to change data | Excel Discussion (Misc queries) | |||
Worksheet change with pivot table | Excel Discussion (Misc queries) | |||
Macro to change a Pivot Table | Excel Discussion (Misc queries) |