Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
From my raw table (left table), I got top 5 states ranked based on the amount(right table).
Remaining states are categorized as others if they aren't top 5.
Now, this needs to be converted into a row with top 5 states and their amount followed by Other, which is the sum of all remaining states. Any ideas?
Attached is the qvw for reference.
This?
This is close enough. Is it possible to display the amount next to states such as
TX 7000 (same row with state and amount) instead of
TX
7000 ?
This may be
Thank you!!!