Percentage in matrix

Question & Answer
,
1

Hi All,

I have a dataset with the following fields: customerId, LastPaymentDate, SignedUpDate and TotalAmount.

I built a matrix where LastPaymentdate is in Rows, SignedUpDate in Columns and Sum(TotalAmount) in Values. The matrix works perfectly, but now I’d like to rebuild it with the percentages, the TotalAmount segmented in rows and columns divided by TotalAmount as you can see in the screenshot.

screenshot
screenshot993×220 4.1 KB

Is that possible?

Thanks

2

Hi @KLIKIN ,

did you check:

BG

3

Thanks it’s just the formula that I’m looking for