Forum Discussion

Jgrohows's avatar
Jgrohows
Frequent Visitor
3 years ago

Matrix with multiple date Columns

Hello! 

 

I am trying to create a Matrix that looks like below.  I got as far as getting the rows sorted, but i cant seem to get the dates into the columns.

 

I basically want to show the following columns

1 - Current Month (CM)

2- Previous Month (PM)

3- CM less PM

4- Current month from Previous Year (CMPY)

5- CM less CMPY

 

Please note i would like the columns to be dynamic, so that if i enter data with date of 2/1/2023, the other columns will update appropriately. 

 

Please let me know if there is anything else i an provide to assist. Below is a sample of the data.

 

MonthyYearDate<0 Days1-119 Days120-359 Days360+ DaysTotal AR
December2022Thursday, December 1, 2022125000125
October2022Saturday, October 1, 202212512500250
November2022Tuesday, November 1, 20221251251250375
September2022Thursday, September 1, 20221251251251251000