Scenario/Pivot Tables
Hi, I was hoping someone could help me with scenarios/pivot tables. I
have 8 scenarios that are set up that feed calculations in 2 of my columns in the data sheet. I would then like to create pivot tables for each of the 8 scenarios. unfortunately i can't use the summary pivot report as it only gives me the option of inputting a total # as a results cell. thanks |
Scenario/Pivot Tables
Instead of using a scenario pivot table, which is very limited, create a
regular pivot table from the data sheet. When you change the scenario, and the calculations show a different result, refresh the pivot table, to see that scenario's summary. dianaweinstein wrote: Hi, I was hoping someone could help me with scenarios/pivot tables. I have 8 scenarios that are set up that feed calculations in 2 of my columns in the data sheet. I would then like to create pivot tables for each of the 8 scenarios. unfortunately i can't use the summary pivot report as it only gives me the option of inputting a total # as a results cell. thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Scenario/Pivot Tables
On Oct 9, 11:23 am, Debra Dalgleish wrote:
Instead of using a scenario pivot table, which is very limited, create a regular pivot table from the data sheet. When you change the scenario, and the calculations show a different result, refresh the pivot table, to see that scenario's summary. dianaweinstein wrote: Hi, I was hoping someone could help me with scenarios/pivot tables. I have 8 scenarios that are set up that feed calculations in 2 of my columns in the data sheet. I would then like to create pivot tables for each of the 8 scenarios. unfortunately i can't use the summary pivot report as it only gives me the option of inputting a total # as a results cell. thanks -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html i was hoping that i could somehow save the results without having to constantly save the values of the pivot tables so that i could do a side by side comparison of the results. any ideas? i was hoping to create a report manager once i have all my views saved. |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com