Hi guys! I hope you can help me with my problem. This is the scenario:
In my field list, I have "Routes" and "Segments"
ROUTE - contains the whole journey of the plane and contains 2 SEGMENTS:
Example:
Route: Manila - Singapore - Manila
Segment 1: Manila - Singapore
Segment 2: Singapore - Manila
Our client wants that if the user click on a ROUTE, (maybe in a slicer), it will display automatically two pie charts containing the segments based on the chosen route.
Please refer to the attached image.
Do you have any idea or suggestion on how to achieve this? please help me. I really need to do this.. Can i make it by means of VBA/macro? Thanks a lot!
Bookmarks