Hi Guys,
I have a problem statement for all. I am from payment industry. Let me explain my problem
Day Failure/success reason Txn_Count
1 No funds 10
1 Cancelled 20
1 Not approved by bank 30
1 Successful 40
Total 100
I want to get below output from above
Day Failure/success reason Txn_count
1 No funds 10%
1 Cancelled 20%
1 Not approved 30%
I want count to be a relative percent i.e 10% for no funds, 20% for cancelled and 30% for not approved. This percent should be calculated with denominator 100 not 60
Also, This is for only on day. If there are many days and I select No funds failure reason, it should show relative share for all individual days.
1 No Funds 40%
2 No Funds 20%
3 No Funds 10%
Right now its showing 100% for all days. Can anyone help here