SAC previous year quantity calculation by week

[adriano1973]

Hello everyone

I have an date input control as a calendar, and I have a table that shows the quantities sold in the chosed year divided by weeks, and this is fine.

Now I want to show, week by week, also the quantities sold in the previous year in that particolar week (example if I see the week 17 in the 2025, I want to show close to this value , the quantity sold in the week 17 for the 2024).

If I try to implement this , SAC doesn't show me the value of the column of the week of the previous year.

If I try to set the hierarchy starting from month, I can see the quantity sold in the same month of the previous year, but if I try to drill down I get this error

Is there a way to achieve the result? And how?

Thank you for your reply

Adriano

[William_Yu]

You can try to use restricted measure to have last year value. 

[adriano1973]

Hi William, I already tried what you suggest me, but I have same error message. In the dimensions droplist I chosed the field "DocDate" , but it seems that SAC cannot allow me to drilldown to week level to see last year information. Any other ideas why does it happen?