Showing previous period sales in same row as current

[gerrycastellino]

In my straight table, on the same row as the current, I'd like to show the previous months sales, or the last years period sales.

How would I structure my expression for this ?

Gerry.

[antoniotiman]

Hi Gerry,

if You use QV 12 then

Aggr(Above(TOTAL Sum({<Date>} Sales)),(Date,(Numeric,Asc)))

Regards,

Antonio

[miranrai]

see here attached. !

[kavita25]

Hello,

Please refer the below link:

How to show current month and previous in the same table with month as a dimension