It depends what the view looks like (perhaps you can post the twbx file?). But, one option may be to turn on subtotals.
Thanks for your response.
I tried to add subtotals, it 's doing fine for the actuals, but the reference line which is the maximum of the budget for each month(actuals and budget come from the same view) is been picked wrong for the quarter subtotal.
Month - Actuals[Bar] -Max(Budget)[Reference Line]
Jan - 2000 - 5000
Feb - 1000- 5000
Mar - 3000 - 50000
Expected Subtotal for the quarter as a bar -Q1 - 6000 - 15000
Actual Subtotal Q1-6000-5000
So I tried to add a cumulative total, which is not working either . I can do a model twbx if it will be still helpful.
Can anyone help me in this query please?