pivot tables and difference from

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

pivot tables and difference from

Post by BittenApple »

Hello team,

I inserted a pivot table on my data. It has two columns: count 2020 and count 2021. I placed mouse on the created pivot table on field 2021 to find % difference from. It created two more fields one for difference between 2021 and 2020, one for difference between 2020 and its prior year. I don't have data for 2019. I wonder if there is a way that I can prevent % difference for 2019 and 2020 is not showing up.

Regards,

BittenApple

User avatar
HansV
Administrator
Posts: 78232
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: pivot tables and difference from

Post by HansV »

Could you attach a sample workbook with some dummy data?
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: pivot tables and difference from

Post by BittenApple »

Hello Hans,
Please find the attached workbook.
Respectfully,
BittenApple
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78232
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: pivot tables and difference from

Post by HansV »

That is not a pivot table.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: pivot tables and difference from

Post by BittenApple »

Hello Hans,

I have inserted a pivot table. I want to know the % difference from last year.
Now it show N/A. My base is 2019 and I want to find out the % difference from 2019 for year 2020.

Please let me know if you have any questions.

Respectfully,

BittenApple
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78232
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: pivot tables and difference from

Post by HansV »

The problem is that the source data have been set up incorrectly. In the attached version, I have restructured the source data to look like a database table, then created a pivot table from the new data.

Percentage Difference From.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: pivot tables and difference from

Post by BittenApple »

Hello Hans,

Yes, that is correct, my organization of my data was not correct. I appreciate your response.

Regards,
BittenApple