P
PeterH
I am working in pivot tables and created the table below
The market share is created by calculating the % of column on the unit volume. I am trying to insert another column all the way to right to calulate the change in market share. When I tried to insert field, but the market share fields (which are calculated) do not show up in order to create a formula. I tried to do it as a calculated item but the insert item is grayed out and it won't let me execute. Any ideas
Sales Mkt Shr Sales Mkt Shr Mkt shr Ch
BAYLINER 547 7.5% 685 9.8%
CARVER 125 1.7% 103 1.5
CHAPARRAL 594 8.2% 709 10.2
COBALT 290 4.0% 297 4.3
The market share is created by calculating the % of column on the unit volume. I am trying to insert another column all the way to right to calulate the change in market share. When I tried to insert field, but the market share fields (which are calculated) do not show up in order to create a formula. I tried to do it as a calculated item but the insert item is grayed out and it won't let me execute. Any ideas
Sales Mkt Shr Sales Mkt Shr Mkt shr Ch
BAYLINER 547 7.5% 685 9.8%
CARVER 125 1.7% 103 1.5
CHAPARRAL 594 8.2% 709 10.2
COBALT 290 4.0% 297 4.3