Ferenc Puskas
New Member
Greetings,
I am creating a dashboard with statistics of students at our language institution. I need help with year-on-year calculation in the pivot table.
My boss wants me to add a year-over-year change to that table (He is a beginner in Excell, so he does not know). My question is if it's feasible, in case the table is connected to slicers (image below, numbers randomized). So far all my attempts have failed. I have watched several tutorials, but haven´t seen any with pivot tables with slicers or similar layouts.
Would be glad if someone can let me know if it's doable with the current layout, or eventually refer me to some guide/forum thread on how to do it.
Thanks!
![1687525367227.png 1687525367227.png](https://chandoo.org/forum/data/attachments/84/84629-b45311750f0a6779743162db7e09102e.jpg)
I am creating a dashboard with statistics of students at our language institution. I need help with year-on-year calculation in the pivot table.
My boss wants me to add a year-over-year change to that table (He is a beginner in Excell, so he does not know). My question is if it's feasible, in case the table is connected to slicers (image below, numbers randomized). So far all my attempts have failed. I have watched several tutorials, but haven´t seen any with pivot tables with slicers or similar layouts.
Would be glad if someone can let me know if it's doable with the current layout, or eventually refer me to some guide/forum thread on how to do it.
Thanks!
- The data set includes data of students from the last 12 years and information about, the institutes and the lenght of their course
- In the dashboard, I have created a pivot table with the numbers of applicants, accepted students, and registered students. The table is connected to slicers of academic years and the length of the course which is also connected to other graphs in the dashboard.
![1687525367227.png 1687525367227.png](https://chandoo.org/forum/data/attachments/84/84629-b45311750f0a6779743162db7e09102e.jpg)