I have a stacked bar color coded on one field.
If user clicks 'Planned' or 'Unplanned' I want to further stack the bar by another slice of field.
I dont mind giving a drop down for further action.
How do I achieve this?
I created a sample workbook based on your description and my assumptions.
Please check the attached for details.
Retrieving data ...