Jun 06 2023 11:01 AM
Hello! I am building my knowledge in pivot tables and building interactive dashboards. At the very end of my dashboard, I am unable to connect my slicer to all the pivot tables. I am unsure why!
I have attached my Excel file with this message. In the worksheet "Data-Accident", the dataset is available. In the worksheet "Dashboard", when you click on the slicers, you can see that, 'MONTHLY TREND' and 'Casualties buy Road Type' does not change. https://docs.google.com/spreadsheets/d/10tx-CPSStU3ZHcQEf2l_gNVEe0P-eiNY/edit?usp=sharing&ouid=10937...
Jun 06 2023 09:13 PM - edited Jun 06 2023 09:13 PM
@SanJims The file in your link doesn't open. At least not for me. Not even after quite a long wait. So I gave up.
Make sure that all pivot tables share the same pivot cache. More about that in the link below.
Jun 07 2023 01:26 AM