Hi,

I have a data range that consists of a main category Called ISSUE and each issue has multiple actions. For example ISS001 has ACT1.1 ,ACT1.2 etc. What I am trying to do is create a stacked bar chart showing the number of issues over time due by month based on their status. The status of the issue is based on the Status of the Action i.e. OPEN, CLOSED, ON_TRACK or OVERDUE.

To further complicate matters a unique Issue eg. ISSS001 is only completely closed once all associated actions are closed.

So my data table is arranged as follows:

Issue Title, Issue ID, Issue Deadline, Action Title, Action ID, Action Deadline, Status, Completion data then I have some columns for Year/Month action, Year/month Issue.

I am struggling to create a a pivot chart that isolates the Issue because of the dependency Issues have on sub category of action. I have tried adding field formulas without any success. I could create a second data range for Issues only but I really only want a single range that captures all the MI.

I hope this makes sense