My data set has statuses for ID's. Starting from Order to Delivered which are based on a date.An ID can in between a status which has not yet delivered.For this I have calculated latest status and created a pie chart. Also created a status cycle line chart.
When I am trying to filter latest status pie chart using action on the other chart, am facing a problem. I am unable to see the whole status cycle. Its filtering on the latest Status.
Attached the sample workbook, please look into it.