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
pivot tables and difference from
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
-
- Administrator
- Posts: 78232
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: pivot tables and difference from
Could you attach a sample workbook with some dummy data?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: pivot tables and difference from
Hello Hans,
Please find the attached workbook.
Respectfully,
BittenApple
Please find the attached workbook.
Respectfully,
BittenApple
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78232
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: pivot tables and difference from
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
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.
-
- Administrator
- Posts: 78232
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: pivot tables and difference from
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.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: pivot tables and difference from
Hello Hans,
Yes, that is correct, my organization of my data was not correct. I appreciate your response.
Regards,
BittenApple
Yes, that is correct, my organization of my data was not correct. I appreciate your response.
Regards,
BittenApple