Pivot table with show value as (Option)

[paxonltd]

I have 2017 and 2018 column, I have added a "Show value as difference from 2018 vs 2017" I do not understand why the Pivot is adding some empty columns (such as "C" - "G" - "K"... and so on).



Is there a way NOT to Show empty columns?

See attached file as example.

Thanks

[MarvinP]

Hi paxonltd,

See if the attached is what you want. I simply moved the "Values" down from Column to the Values box.

2017vs2018 PT.xlsx