Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,sorry to ask again but I need so much solve this please.
I need to show information like this:
Type Position in the Rank Ranking Change Value Change
Overall 5 -2 -18,5%
UK 10 3 5,5%
Italy 15 0 -7,3%
I seems easy but it is all depending of rank calculation
In the attached file I´ve created 3 dynamic tables but if there is no other way to visualize, I need at least in the second and thirdy one see only the last column with the results.
Who can give me a hint to show this better?
Looking to get this?
Added a table in the script:
Dim:
LOAD * Inline [
Dim
1
2
3
];
Dimensions
Broker Group Name
Dim
Expression (Just showing the 1st one, rest can be see in the attached application)
Pick(Dim,
Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),
Rank(Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1)
-
Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),
Num(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)
/
Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)
-1, '##,0%'))
Looking to get this?
Added a table in the script:
Dim:
LOAD * Inline [
Dim
1
2
3
];
Dimensions
Broker Group Name
Dim
Expression (Just showing the 1st one, rest can be see in the attached application)
Pick(Dim,
Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),
Rank(Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1)
-
Rank(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP])) * Avg(1),
Num(Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)
/
Sum({1<[Reporting Calendar Year]={'$(vYearBefore)'},[Reporting Calendar Quarter]={'$(vQuarter)'}>} [Gross Premium GBP]) * Avg(1)
-1, '##,0%'))
Thank You so so much! This is perfect for me.
Best Regards
You built all the expressions!! I´m so ashamed you had this work for me. Anything you need help, count on me ok?
You´re the best
Don't have to be ashamed my friend, you did not force me to do this, I just thought that I should complete what I have started .
Best,
Sunny