Calculate Moving Medians by Entity for a dataset with multiple Entities

[Edotime]

I believe this is a bit advance (although I hope not).  Hoping someone might be able to provide some guidance. 

I have these entities called a "structure" and each structure has multiple and a varying number of entries by month.  The attached data has data for months 1 to 5,  and I'd like Alteryx to calculate the median by month of the fields "UNIT_PRICE" and "PRICE_OVER_COST" using the most recent three months of data.  The results should be as follows (where the last column is a description and is not needed in the output generated by Alteryx)

Structure     Month     Median Price     Median Price Over Cost     Data used to Calculate Median

A                  3              996.13                  .70115                             Months 1 - 3 for Structure A

A                  4              1061.45                 .74713                            Months 2 - 4 for Structure A

A                  5               1143.1                   .80460                            Months 3 - 5 for Structure A

B                  3               962.27                   .86075                           Months 1 - 3 for Structure B

B                  4               966.155                 .86422                            Months 2 - 4 for Structure B

B                  5                1079.52                .94207                           Months 3 - 5 for Structure B

Any guidance on how I can accomplish this?  Data attached.  Thanks all!

[CoG · Accepted solution]

Here is a sample workflow:

[Edotime · Accepted solution]

This is Genius!  Appreciate the guidance.