Forum Discussion
Comparing FY's In A Matrix From A Single Date Column Within Data Ideally Using SAMEPERIODLASTYEAR
I've searched the forums for hours now, but can't seem to find a solution that will work for me. I'm using a matrix that almost works, but not the way I want. In the matrix below, FY19 is compar...
Hi,
Share sample raw data and show the expected result.
Thanks for your reply. Here's some sample data:
CUSTOMER INVOICE DATE INVOICE TOTAL A 1/31/2019 2836.49 A 7/25/2019 2562.85 A 11/8/2019 2730.3 A 12/11/2019 3013.05 A 2/18/2020 2568.24 B 1/31/2019 844 B 11/3/2019 912 B 12/31/2019 912 C 9/26/2019 2549.97 C 9/26/2019 2829.27 C 11/21/2019 2819.32 C 11/21/2019 2729.44 C 12/24/2019 3442.55 C 12/24/2019 2397.13 C 2/7/2020 2963.6 C 2/7/2020 2746 C 3/4/2020 2923.39 C 3/4/2020 3014.45 C 3/6/2020 2867.81 Here's what I need to see in the matrix from this sample data:
FY19 FY20 TOTAL: 11622.58 36039.28 CUSTOMER FY ($) FY ($) A 5399.34 8311.59 B 844 1824 C 5379.24 25903.69