I have list of activities and each has assigned default group/ bundle. In Tableau I might want to see how the charts are changing when I add additional activity to a bundle.
Example: I select Bundle C (i.e. activities 10-15) with SUM of Values 750. I would like to add activity 1 as well and see SUM 760 instead.
I am including the Tableau file and Excel input sheet.
Any suggestion how to do it - settings of filters, changing data to different format, customizing Activities filter so it automatically pre-selects activities which belong to selected bundle etc. - are appreciated.
Thank you. Kami