Forum Discussion

dtalb's avatar
dtalb
Regular Visitor
3 years ago

Martix run-off calculation

Hi

 

I have a matrix/pivot table visual like this:

Date Row = is the cohort ie sales date

Date Column = is the transaction date

 

I need to work out the percentage relative to the first value in the row (ie the diagonal):

 

How do I create a measure that returns the value in the diagonal in all the columns:

 

Thanks

 

 

2 Replies