Diagonal Calculations - Data and App

[ofalana1674]

Hi All: ( I am re-posting this to include Data and App)

I am not sure if this is possible but I am trying to determine the roll of customers with certain balances from month to month. For example, I want to know the percentage of customers with balances over $5000 in Month 1, whose balance dropped to between $2500 to $4999 in Month 2 . So in the example below (follow beige highlights), 2,000 customers had balances above $5000 in Month 1, out of these 2000, about 1,500 had reduced their balance to between $2500 to $4999 by Month 2 etc. The second table just shows this roll in percentage terms . Is there a way I can replicate the second table (percentages) in a Qlikview Pivot Table?:

[sunny_talwar · Accepted solution]

Try this

=Sum(CustomerCount)/Before(Above(Sum(CustomerCount)))

[ofalana1674]

Thanks Sunny! It works!