Please advise on how I can create the following report. The report is supposed to be a worksheet view showing Net sales for the month, lets say a report for today, it should have dates columns up to 10th  september [1...10] each showing total sales of the day. Another column should be  added to the end showing the total sales for last year same month .. in our case it should show total sales for the whole month of Sepember 2023.

I have put the Transactiondate as a pivot & Netsales as a column. The challenge is to introduce sales for last year as a calculated column.

I have the following columns :Netsales, Transactiondate, Fiscyear, Fiscperiod, DocumentNo.