Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to create the chart to show the sum of account balances of top N accounts. I need to create the below chart. If I select any date , I want show the chart like below:
Top 5 --> Sum of Top 5 Account Balances
Top 5 Accounts --> List of Accounts Top 5 Accounts List (EX: 2, 5, 8, 20, 4)
TOP 5 | TOP 5 Account | Top 10 | Top 25 | Top 75 | |
MonthEnd | |||||
QTD | |||||
PQTD | |||||
P2QTD | |||||
YTD |
Please find the attached sample QVD file for sample data.
Any Help ?
I didn't want to downloaded you data, sorry... See a simple example attached. It will be easy to apply the same rules to all your expressions.
Hi Mike Thanks for the reply. I am encountering two probelms.
1. I want show only 5 Accounts. Example for 12/13 it was showing 6 accounts. How to give the unique ranking if the rank value matching.
2. I want show MonthEnd (Total Month), QTD , PQTD (Previous Quarter) , P2QTD (Previous 2 Quarters) and YTD value for selected date
Please find the attached sample data.
hi dude,
Am attaching a doccument for only top 5 accoounts
I have very huge data and your expression went out of memory.
I am looking for how to give unique ranking if the value matching
Use Dimension limits and select show only 5 higest values
and remove selection "show others"
I want show Top 5 accounts in one cell value like : 10, 45, 67, 2, 23