How to see Budget vs Actual totals separately?

Hi Muz,

Can you show us you summary setup and the pivot so we can understand better ?

Thanks

Hi @Muz 

As @Nathan mentioned, you can aggregate Actual and Budget Month>Year and you can achieve your result.

For your reference, I am providing Screenshot below therefore you can see Total of Actual and Budget saperately.

Thanks.

Hi @abhilashsawla 

I dont see Actual or Budget aggregators as per your screenshot in my Table.. how to bring the Versions dimension as an aggregator?

Hi @Muz 

Now, I have understood your case,

Please use the sum option for Month>sum and turn on the toggle of Show Every Subtotal

Please find screenshot here for your immediate reference.

Thanks

Thanks @abhilashsawla, this worked. But there is a problem in arrangement of columns in the Total. Dont know if this is system issue as i cannot rearrange them.

@abhilashsawla & @Nathan - selecting the “Show every subtotal” shows the A3 totals on top and then the A2 & A3 subtypes.. this is not required.. 

Below is the breakup without selecting the “Show every subtotal” option

 

Please remove A3 Subtype Sum Aggregation from View Aggregators.