Hi All - I am attempting to show the Cumulative Sales for a Partner ONLY within the Calendar Year that the Partner registered . I have the following information in my table(s).
I have 3 years of daily sales data, 2018, 2019, and 2020.
Partner Registration Date (MM/DD/YYYY)
In a matrix, my data should look like this:
Create year Jan Feb Mar
2018 $100 $350 $500
2019 $125 $225 $333
2020 $130 $270 $444
My end goal is to show a Line Chart visual in which the Axis is the Month name, the Legend is the Partner Creation Year (2018, 2019, and 2020), and the Values are the Cumulative Sales of the partners.
Any help would be greatly appreciated.