Matthew112
New Member
Hi all.
I have inserted a sample file with what I would like to do. I have the first pivot table set up to display sales by product. That table has its year slicer and product slicer.
Now the second table I would like to set up to display only 2 years of data. The year selected on the pivot slicer and the previous year for comparison. I want the data to be displayed on a line chart as shown.
Could anyone explain what I would have to do to get that working? I have many pivot tables in my workbook and if I understand how to do one than I can do the rest. I'm not familiar with creating new measures yet, still learning that part.
I have inserted a sample file with what I would like to do. I have the first pivot table set up to display sales by product. That table has its year slicer and product slicer.
Now the second table I would like to set up to display only 2 years of data. The year selected on the pivot slicer and the previous year for comparison. I want the data to be displayed on a line chart as shown.
Could anyone explain what I would have to do to get that working? I have many pivot tables in my workbook and if I understand how to do one than I can do the rest. I'm not familiar with creating new measures yet, still learning that part.