Hi Team - I watch your you tube videos and I have grown so much in knowledge, I simply cant say thank you enough. I have posted on the comments section and was referred to the forum. So Here goes. As per the screen shot I Have created myself an excel dashboard or at least tried to, based on my budget. The goal was to make it as automated as possible but have not yet done that. But its getting there. In the screen shot I would like to View the category's transactions that is linked to them. At the moment I need to jump to the Pivots then double click on the category to open a new sheet with the required data. Or I need to Go to the Transactions sheet and start filtering. Please advice me what videos to watch or what I need to google in order to achieve this is this is possible. I am going through slicer videos at the moment
I managed to come right. I found a YouTube Video and Managed to play around till I got the desired results
https://www.youtube.com/watch?v=pl0jgbuOqhk
Thanks again for the help