Hi,
I built a pivot table in Excel 2010 on basic data to count # of employees by state. I then used the "show values as" feature to show the count as % of the grand total. The next step is to apply these percentages to total revenue to allocate 2015 revenue by state.
The question is can I somehow create a calculated field that will use the "show values as" percentage and multiply it against a total revenue value. I haven't been able to do it as the calculated field wants to use the raw data only. I thought I would ask as I might be missing something.
Thanks
Brenda
I built a pivot table in Excel 2010 on basic data to count # of employees by state. I then used the "show values as" feature to show the count as % of the grand total. The next step is to apply these percentages to total revenue to allocate 2015 revenue by state.
The question is can I somehow create a calculated field that will use the "show values as" percentage and multiply it against a total revenue value. I haven't been able to do it as the calculated field wants to use the raw data only. I thought I would ask as I might be missing something.
Thanks
Brenda
