Sales Comparison with LY and CY in Cloud

[KatyKab]

Hi, I would like to know How can I calculate the LY (Last Year) in a database of 4 years, I want to compare LY and CY (Current Year). I have a database with the monthkey, Sales for everyday$$, product attributes, Thank you for your help.

[alexnajm]

Without knowing your data structure, I'd likely:

• use a Formula to label LY vs CY vs non-CY-or-LY
• Filter to only CY and LY
• Summarize, grouping on your label column and summing sales