Want to show this year puchase amount vs last year puchase amount using bar chart

[Vinni2000]

i have invoice date '20200831' format in purchase order data so now i want to compare thise year purchase amount vs last year purchase amount by months using bar chart 

[_Iswarya_]

Hi @Vinni2000 ,

First get the year in the script using:

Year(Date#(FieldName, 'YYYYMMDD')) as Year

Sum({<Year = {"$(=Max(Year))"}>}purchase_amount)

Previous Year:

Sum({<Year = {"$(=Max(Year)-1)"}>}purchase_amount)