Excuse my limited q.v. knowledge. I got a table of data (50k+ rows)
Account name, Aging, Risk Category, Notional Amt, Start date
Ltfv, 13, Unconfirmed, $200, 05232018
Ltfv, 14, Unconfirmed, $200,05232018
Ltfv, 15, Unconfirmed, $200,05232018
Ltfv, 2, Unconfirmed, $450, 09162018
Ltfv, 3, Unconfirmed, $450, 09162018
Ltfv, 17, non receipt, $1000, 11282017
Ltfv, 18, non receipt, $1000, 11282017
Ltfv, 19, non receipt, $1000, 11282017
.
.
Ltfv, 27, non receipt, $1000, 11282017
Ltfv, 26, Unconfirmed, $150, 06112017
Ltfv, 27, Unconfirmed, $150, 06112017
Ltfv, 28, Unconfirmed, $150, 06112017
Ltfv, 29, Unconfirmed, $150, 06112017
Ltfv, 4, Unchecked, $330, 08232016
Ltfv, 5, Unchecked, $330, 08232016
Ltfv, 6, Unchecked, $330, 08232016
Ltfv, 7, Unchecked, $330, 08232016
Ltfv, 8 Unchecked, $330, 08232016
Glob, 18, non receipt, $240, 09222017
Glob, 19, non receipt, $240, 09222017
Glob, 20, non receipt, $240, 09222017
Glob, 21, non receipt, $240, 09222017
.
.
Each Account name case is differed by Notional Amt & Start date. I need to have a summary chart that ranks the Account name by Risk Category and Total count(Aging). E.g.
Daal relates to 3 different Risk Category (unconfirmed, non receipt and unchecked) so ranks top.
Expected result of top 30 table:
Rank, Account name, Risk Category, Total distinct count(Aging), Outstanding days
1, Ltfv, Unconfirmed, 3, 9 (because 3 + 2 + 4)
1, Ltfv, non receipt, 1, 11 (because from 17 to 27)
1, Ltfv, Unchecked, 1, 5 (because from 4 to 😎
2, Glob, non receipt, 1, 4 (because from 18 to 21)
.
.
Pls provide the QVW sample. Your help is much appreciated!!
