Calculated Item Causing issues in Pivot Table

[broncosrul]

I have a set of data that is 4 items divided into 2 categories and then monthly sales over 2 years. An example of the data is:

[TABLE="width: 497"]
<tbody>[TR]
[TD]Category

[/TD]
[TD]Item Description

[/TD]
[TD]Month

[/TD]
[TD]Year

[/TD]
[TD]Units Sold

[/TD]
[TD]Revenue

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Basketball

[/TD]
[TD]April

[/TD]
[TD]2016

[/TD]
[TD]20

[/TD]
[TD]160

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Baseball

[/TD]
[TD]April

[/TD]
[TD]2016

[/TD]
[TD]40

[/TD]
[TD]144

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Monopoly

[/TD]
[TD]April

[/TD]
[TD]2016

[/TD]
[TD]60

[/TD]
[TD]900

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Trouble

[/TD]
[TD]April

[/TD]
[TD]2016

[/TD]
[TD]30

[/TD]
[TD]300

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Basketball

[/TD]
[TD]April

[/TD]
[TD]2017

[/TD]
[TD]12

[/TD]
[TD]96

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Baseball

[/TD]
[TD]April

[/TD]
[TD]2017

[/TD]
[TD]61

[/TD]
[TD]276

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Monopoly

[/TD]
[TD]April

[/TD]
[TD]2017

[/TD]
[TD]14

[/TD]
[TD]210

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Trouble

[/TD]
[TD]April

[/TD]
[TD]2017

[/TD]
[TD]25

[/TD]
[TD]250

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Basketball

[/TD]
[TD]August

[/TD]
[TD]2016

[/TD]
[TD]15

[/TD]
[TD]120

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Baseball

[/TD]
[TD]August

[/TD]
[TD]2016

[/TD]
[TD]30

[/TD]
[TD]112

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Monopoly

[/TD]
[TD]August

[/TD]
[TD]2016

[/TD]
[TD]45

[/TD]
[TD]675

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Trouble

[/TD]
[TD]August

[/TD]
[TD]2016

[/TD]
[TD]23

[/TD]
[TD]230

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Basketball

[/TD]
[TD]August

[/TD]
[TD]2017

[/TD]
[TD]30

[/TD]
[TD]240

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Baseball

[/TD]
[TD]August

[/TD]
[TD]2017

[/TD]
[TD]50

[/TD]
[TD]44

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Monopoly

[/TD]
[TD]August

[/TD]
[TD]2017

[/TD]
[TD]24

[/TD]
[TD]360

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Trouble

[/TD]
[TD]August

[/TD]
[TD]2017

[/TD]
[TD]70

[/TD]
[TD]700

[/TD]
[/TR]
</tbody>[/TABLE]

And I can easily pivot into this:

[TABLE="width: 801"]
<tbody>[TR]
[TD]Sum of Revenue

[/TD]
[TD][/TD]
[TD]Month

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Item Description

[/TD]
[TD]Year

[/TD]
[TD]January

[/TD]
[TD]February

[/TD]
[TD]March

[/TD]
[TD]April

[/TD]
[TD]May

[/TD]
[TD]June

[/TD]
[TD]July

[/TD]
[TD]August

[/TD]
[TD]September

[/TD]
[TD]October

[/TD]
[TD]November

[/TD]
[TD]December

[/TD]
[/TR]
[TR]
[TD]Baseball

[/TD]
[TD]2017

[/TD]
[TD]216

[/TD]
[TD]40

[/TD]
[TD]88

[/TD]
[TD]220

[/TD]
[TD]100

[/TD]
[TD]172

[/TD]
[TD]28

[/TD]
[TD]188

[/TD]
[TD]212

[/TD]
[TD]116

[/TD]
[TD]64

[/TD]
[TD]144

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]36

[/TD]
[TD]160

[/TD]
[TD]176

[/TD]
[TD]144

[/TD]
[TD]160

[/TD]
[TD]128

[/TD]
[TD]144

[/TD]
[TD]112

[/TD]
[TD]120

[/TD]
[TD]88

[/TD]
[TD]96

[/TD]
[TD]64

[/TD]
[/TR]
[TR]
[TD]Basketball

[/TD]
[TD]2017

[/TD]
[TD]184

[/TD]
[TD]336

[/TD]
[TD]368

[/TD]
[TD]344

[/TD]
[TD]216

[/TD]
[TD]80

[/TD]
[TD]504

[/TD]
[TD]552

[/TD]
[TD]264

[/TD]
[TD]472

[/TD]
[TD]400

[/TD]
[TD]432

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]160

[/TD]
[TD]176

[/TD]
[TD]144

[/TD]
[TD]160

[/TD]
[TD]128

[/TD]
[TD]144

[/TD]
[TD]112

[/TD]
[TD]120

[/TD]
[TD]88

[/TD]
[TD]96

[/TD]
[TD]64

[/TD]
[TD]72

[/TD]
[/TR]
[TR]
[TD]Monopoly

[/TD]
[TD]2017

[/TD]
[TD]495

[/TD]
[TD]225

[/TD]
[TD]330

[/TD]
[TD]570

[/TD]
[TD]75

[/TD]
[TD]375

[/TD]
[TD]600

[/TD]
[TD]135

[/TD]
[TD]870

[/TD]
[TD]465

[/TD]
[TD]855

[/TD]
[TD]585

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]900

[/TD]
[TD]990

[/TD]
[TD]810

[/TD]
[TD]900

[/TD]
[TD]720

[/TD]
[TD]810

[/TD]
[TD]630

[/TD]
[TD]675

[/TD]
[TD]495

[/TD]
[TD]540

[/TD]
[TD]360

[/TD]
[TD]405

[/TD]
[/TR]
[TR]
[TD]Trouble

[/TD]
[TD]2017

[/TD]
[TD]640

[/TD]
[TD]670

[/TD]
[TD]480

[/TD]
[TD]200

[/TD]
[TD]60

[/TD]
[TD]80

[/TD]
[TD]600

[/TD]
[TD]290

[/TD]
[TD]380

[/TD]
[TD]520

[/TD]
[TD]250

[/TD]
[TD]170

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]300

[/TD]
[TD]330

[/TD]
[TD]270

[/TD]
[TD]300

[/TD]
[TD]240

[/TD]
[TD]270

[/TD]
[TD]210

[/TD]
[TD]230

[/TD]
[TD]170

[/TD]
[TD]180

[/TD]
[TD]120

[/TD]
[TD]140
[/TD]
[/TR]
</tbody>[/TABLE]

Then I inserted a calculated item for the % change. The formula being =(2017-2016)/2016 and it looks fine.

[TABLE="width: 1060"]
<tbody>[TR]
[TD]Sum of Revenue

[/TD]
[TD][/TD]
[TD]Month

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Item Description

[/TD]
[TD]Year

[/TD]
[TD]January

[/TD]
[TD]February

[/TD]
[TD]March

[/TD]
[TD]April

[/TD]
[TD]May

[/TD]
[TD]June

[/TD]
[TD]July

[/TD]
[TD]August

[/TD]
[TD]September

[/TD]
[TD]October

[/TD]
[TD]November

[/TD]
[TD]December

[/TD]
[/TR]
[TR]
[TD]Baseball

[/TD]
[TD]2017

[/TD]
[TD]216

[/TD]
[TD]40

[/TD]
[TD]88

[/TD]
[TD]220

[/TD]
[TD]100

[/TD]
[TD]172

[/TD]
[TD]28

[/TD]
[TD]188

[/TD]
[TD]212

[/TD]
[TD]116

[/TD]
[TD]64

[/TD]
[TD]144

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]36

[/TD]
[TD]160

[/TD]
[TD]176

[/TD]
[TD]144

[/TD]
[TD]160

[/TD]
[TD]128

[/TD]
[TD]144

[/TD]
[TD]112

[/TD]
[TD]120

[/TD]
[TD]88

[/TD]
[TD]96

[/TD]
[TD]64

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Change

[/TD]
[TD]500%

[/TD]
[TD]-75%

[/TD]
[TD]-50%

[/TD]
[TD]53%

[/TD]
[TD]-38%

[/TD]
[TD]34%

[/TD]
[TD]-81%

[/TD]
[TD]68%

[/TD]
[TD]77%

[/TD]
[TD]32%

[/TD]
[TD]-33%

[/TD]
[TD]125%

[/TD]
[/TR]
[TR]
[TD]Basketball

[/TD]
[TD]2017

[/TD]
[TD]184

[/TD]
[TD]336

[/TD]
[TD]368

[/TD]
[TD]344

[/TD]
[TD]216

[/TD]
[TD]80

[/TD]
[TD]504

[/TD]
[TD]552

[/TD]
[TD]264

[/TD]
[TD]472

[/TD]
[TD]400

[/TD]
[TD]432

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]160

[/TD]
[TD]176

[/TD]
[TD]144

[/TD]
[TD]160

[/TD]
[TD]128

[/TD]
[TD]144

[/TD]
[TD]112

[/TD]
[TD]120

[/TD]
[TD]88

[/TD]
[TD]96

[/TD]
[TD]64

[/TD]
[TD]72

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Change

[/TD]
[TD]15%

[/TD]
[TD]91%

[/TD]
[TD]156%

[/TD]
[TD]115%

[/TD]
[TD]69%

[/TD]
[TD]-44%

[/TD]
[TD]350%

[/TD]
[TD]360%

[/TD]
[TD]200%

[/TD]
[TD]392%

[/TD]
[TD]525%

[/TD]
[TD]500%

[/TD]
[/TR]
[TR]
[TD]Monopoly

[/TD]
[TD]2017

[/TD]
[TD]495

[/TD]
[TD]225

[/TD]
[TD]330

[/TD]
[TD]570

[/TD]
[TD]75

[/TD]
[TD]375

[/TD]
[TD]600

[/TD]
[TD]135

[/TD]
[TD]870

[/TD]
[TD]465

[/TD]
[TD]855

[/TD]
[TD]585

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]900

[/TD]
[TD]990

[/TD]
[TD]810

[/TD]
[TD]900

[/TD]
[TD]720

[/TD]
[TD]810

[/TD]
[TD]630

[/TD]
[TD]675

[/TD]
[TD]495

[/TD]
[TD]540

[/TD]
[TD]360

[/TD]
[TD]405

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Change

[/TD]
[TD]-45%

[/TD]
[TD]-77%

[/TD]
[TD]-59%

[/TD]
[TD]-37%

[/TD]
[TD]-90%

[/TD]
[TD]-54%

[/TD]
[TD]-5%

[/TD]
[TD]-80%

[/TD]
[TD]76%

[/TD]
[TD]-14%

[/TD]
[TD]138%

[/TD]
[TD]44%

[/TD]
[/TR]
[TR]
[TD]Trouble

[/TD]
[TD]2017

[/TD]
[TD]640

[/TD]
[TD]670

[/TD]
[TD]480

[/TD]
[TD]200

[/TD]
[TD]60

[/TD]
[TD]80

[/TD]
[TD]600

[/TD]
[TD]290

[/TD]
[TD]380

[/TD]
[TD]520

[/TD]
[TD]250

[/TD]
[TD]170

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016

[/TD]
[TD]300

[/TD]
[TD]330

[/TD]
[TD]270

[/TD]
[TD]300

[/TD]
[TD]240

[/TD]
[TD]270

[/TD]
[TD]210

[/TD]
[TD]230

[/TD]
[TD]170

[/TD]
[TD]180

[/TD]
[TD]120

[/TD]
[TD]140

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Change

[/TD]
[TD]113%

[/TD]
[TD]103%

[/TD]
[TD]78%

[/TD]
[TD]-33%

[/TD]
[TD]-75%

[/TD]
[TD]-70%

[/TD]
[TD]186%

[/TD]
[TD]26%

[/TD]
[TD]124%

[/TD]
[TD]189%

[/TD]
[TD]108%

[/TD]
[TD]21%
[/TD]
[/TR]
</tbody>[/TABLE]

However, if I add the category, I end up with lines that don't make any sense. Now I have calculated items for balls in the Game Category and vice versa. And these are not lines anywhere in the data, so I am not sure where they are coming from. Can anyone tell me what is happening and how to fix it? And if it can't be fixed, if there is a workaround. You can see below what I am seeing:

[TABLE="width: 1207"]
<tbody>[TR]
[TD]Sum of Revenue

[/TD]
[TD][/TD]
[TD][/TD]
[TD]Month

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Category

[/TD]
[TD]Item Description

[/TD]
[TD]Year

[/TD]
[TD]January

[/TD]
[TD]February

[/TD]
[TD]March

[/TD]
[TD]April

[/TD]
[TD]May

[/TD]
[TD]June

[/TD]
[TD]July

[/TD]
[TD]August

[/TD]
[TD]September

[/TD]
[TD]October

[/TD]
[TD]November

[/TD]
[TD]December

[/TD]
[/TR]
[TR]
[TD]Balls

[/TD]
[TD]Baseball

[/TD]
[TD]2017

[/TD]
[TD]216

[/TD]
[TD]40

[/TD]
[TD]88

[/TD]
[TD]220

[/TD]
[TD]100

[/TD]
[TD]172

[/TD]
[TD]28

[/TD]
[TD]188

[/TD]
[TD]212

[/TD]
[TD]116

[/TD]
[TD]64

[/TD]
[TD]144

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2016

[/TD]
[TD]36

[/TD]
[TD]160

[/TD]
[TD]176

[/TD]
[TD]144

[/TD]
[TD]160

[/TD]
[TD]128

[/TD]
[TD]144

[/TD]
[TD]112

[/TD]
[TD]120

[/TD]
[TD]88

[/TD]
[TD]96

[/TD]
[TD]64

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Change

[/TD]
[TD]500%

[/TD]
[TD]-75%

[/TD]
[TD]-50%

[/TD]
[TD]53%

[/TD]
[TD]-38%

[/TD]
[TD]34%

[/TD]
[TD]-81%

[/TD]
[TD]68%

[/TD]
[TD]77%

[/TD]
[TD]32%

[/TD]
[TD]-33%

[/TD]
[TD]125%

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Basketball

[/TD]
[TD]2017

[/TD]
[TD]184

[/TD]
[TD]336

[/TD]
[TD]368

[/TD]
[TD]344

[/TD]
[TD]216

[/TD]
[TD]80

[/TD]
[TD]504

[/TD]
[TD]552

[/TD]
[TD]264

[/TD]
[TD]472

[/TD]
[TD]400

[/TD]
[TD]432

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2016

[/TD]
[TD]160

[/TD]
[TD]176

[/TD]
[TD]144

[/TD]
[TD]160

[/TD]
[TD]128

[/TD]
[TD]144

[/TD]
[TD]112

[/TD]
[TD]120

[/TD]
[TD]88

[/TD]
[TD]96

[/TD]
[TD]64

[/TD]
[TD]72

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Change

[/TD]
[TD]15%

[/TD]
[TD]91%

[/TD]
[TD]156%

[/TD]
[TD]115%

[/TD]
[TD]69%

[/TD]
[TD]-44%

[/TD]
[TD]350%

[/TD]
[TD]360%

[/TD]
[TD]200%

[/TD]
[TD]392%

[/TD]
[TD]525%

[/TD]
[TD]500%

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Monopoly

[/TD]
[TD]Change

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Trouble

[/TD]
[TD]Change

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[/TR]
[TR]
[TD]Balls Total

[/TD]
[TD][/TD]
[TD][/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[/TR]
[TR]
[TD]Games

[/TD]
[TD]Baseball

[/TD]
[TD]Change

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Basketball

[/TD]
[TD]Change

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Monopoly

[/TD]
[TD]2017

[/TD]
[TD]495

[/TD]
[TD]225

[/TD]
[TD]330

[/TD]
[TD]570

[/TD]
[TD]75

[/TD]
[TD]375

[/TD]
[TD]600

[/TD]
[TD]135

[/TD]
[TD]870

[/TD]
[TD]465

[/TD]
[TD]855

[/TD]
[TD]585

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2016

[/TD]
[TD]900

[/TD]
[TD]990

[/TD]
[TD]810

[/TD]
[TD]900

[/TD]
[TD]720

[/TD]
[TD]810

[/TD]
[TD]630

[/TD]
[TD]675

[/TD]
[TD]495

[/TD]
[TD]540

[/TD]
[TD]360

[/TD]
[TD]405

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Change

[/TD]
[TD]-45%

[/TD]
[TD]-77%

[/TD]
[TD]-59%

[/TD]
[TD]-37%

[/TD]
[TD]-90%

[/TD]
[TD]-54%

[/TD]
[TD]-5%

[/TD]
[TD]-80%

[/TD]
[TD]76%

[/TD]
[TD]-14%

[/TD]
[TD]138%

[/TD]
[TD]44%

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Trouble

[/TD]
[TD]2017

[/TD]
[TD]640

[/TD]
[TD]670

[/TD]
[TD]480

[/TD]
[TD]200

[/TD]
[TD]60

[/TD]
[TD]80

[/TD]
[TD]600

[/TD]
[TD]290

[/TD]
[TD]380

[/TD]
[TD]520

[/TD]
[TD]250

[/TD]
[TD]170

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]2016

[/TD]
[TD]300

[/TD]
[TD]330

[/TD]
[TD]270

[/TD]
[TD]300

[/TD]
[TD]240

[/TD]
[TD]270

[/TD]
[TD]210

[/TD]
[TD]230

[/TD]
[TD]170

[/TD]
[TD]180

[/TD]
[TD]120

[/TD]
[TD]140

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Change

[/TD]
[TD]113%

[/TD]
[TD]103%

[/TD]
[TD]78%

[/TD]
[TD]-33%

[/TD]
[TD]-75%

[/TD]
[TD]-70%

[/TD]
[TD]186%

[/TD]
[TD]26%

[/TD]
[TD]124%

[/TD]
[TD]189%

[/TD]
[TD]108%

[/TD]
[TD]21%

[/TD]
[/TR]
[TR]
[TD]Games Total

[/TD]
[TD][/TD]
[TD][/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!

[/TD]
[TD]#DIV/0!
[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance

Travis

 

[Zubair Muhammad]

Hi Travis,

I always have had problems with CALCULATED ITEMS too.

I suggest that you use Power Query to add a calculated item for %change

1) Load the table
2) Pivot the Column Year using Revenues as Values
3) Use "Group by" to
4) Add a calculated Column for change
5) Then Unpivot


Have you used PQ before?

 

[broncosrul]

I haven't used Power Query before and I don't think I have it available. I know Microsoft split out Power Pivot and only certain versions of 2016 come with the addins. When I try to enable the addins, I don't have any in the COM addins where I would expect to see these. So, my guess is that my company is using one of the versions of 2016 that doesn't include Power Pivot and Power Query. So, I don't know a workaround to being able to use it.

 

[Zubair Muhammad]

In Excel 2016, Power Query exists by the name of "Get & Transform"

Go to "DATA" tab, you will see it there

For earlier versions of Excel, you can download this ADD-In from link below

https://www.microsoft.com/en-sa/dow...rue&751be11f-ede8-5a0c-058c-2ee190a24fa6=True