Solved my own problem, think I was making it more complicated than it needed.
I created a Pivot with a Grand Total for all months by Cause factor
Then I used the Month as a filter into that Pivot to get my variable inputs for the grand total.
Created my pie chart from the above table and it works nicely.
Bookmarks