Hi, i dont know if you will be able to open the attached workbook so ill try to give steps as to how i solved it.
Hopefully this helps.
First i made a field called "Order Month" and replaced the date you had in both your chart and table.
Then instead of using the action you had i created two separate action filters. One of them for the field "Order Month" and one for the field "category".
Reference Workbook (2).twbx 1.2 MB
Hi Chris Moore,
Thanks a lot for your prompt response and solution. i think it should works for me.
Really appreciate your help.