List the Selected month VS previous months charges and the differences

[utilities]

Hello all, I have just started using QS and would like to try and generate an app as above where I can select a month and the app is to list the Selected month VS Previous months charges and the difference between the two for each measure/charge.

I have played around with the settings but cannot find anything to accomplish this.

Thanking you in advance.

Regards

Deon

[Gysbert_Wassenaar]

If you select one specific month you can use expressions like

Selected month: sum( charges )

Previous month: sum( {<PeriodID=P(PrevPeriodID)>}charges )

Difference: rangesum(sum( charges ), -sum( {<PeriodID=P(PrevPeriodID)>}charges ) )

[utilities]

Hi Gysbert, thank you for the reply.

It seems that this will work although I am very novice to QS and not even sure where or how to implement this, so I am still working on it.

Regards