Calculation compared to the same period of the previous year

[andreab]

Hi

how can I calculate the same variable period compared to the previous year?

for example, compared to the current month, I would like to have a dashboard that tells me how many leads I have generated compared to the previous year

therefore 1-8 September 2023 compared to 1-8 September 2022

tomorrow it should be updated, however, calculating from 1 to 9 September, so until the end of the month

then it should start again from the following month with the same calculation

thanks
andrea

[duncan]

Hello @andreab !

Have you tried the calculated field in the solution provided here?

Compare period with same period last year in pivot table

Hello, I currently have a pivot table that shows rental information for my product broken down by region. This data is filtered by a Start and End date parameter as seen in this screenshot: [Screen Shot 2022-07-19 at 9.55.09 AM] I want to add a Year-over-Year capability to this table so that in addition to seeing data in the selected date range, we also see the data in the same month/day range for the previous year. So n this example, we are viewing data from June 15, 2022 to July 31, 2022…

[andreab]

@duncan

Have you tried the calculated field in the solution provided here?

Hello @duncan
no, It should be fine

Thank you