Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am calculating rank in a table. my report looks like after selecting a dimension like below.
X | Y | YTD sales | XY Rank | Y rank |
9000 | 1 | 19 | ||
8000 | 2 | 27 | ||
7000 | 5 | 83 | ||
6000 | ||||
5000 |
Rank calculation is done based on this below expression.
XY Rank = Aggr(Nodistinct rank(sum({$<[Process Date]={">=$(=YearStart(Max([Process Date]))) <=$(=Max([Process Date]))"},
[Month ID]=>}[Sales Amt]),4),X,Y).
Y Rank=aggr(Nodistinct rank(sum({$<
But the problem is when I am selecting other dimension like Month Id the rank calculation is not based on this particular month so by selecting a particular month rank is showing 1,2,3,6,9,12, like this as other position not part in this month so they removed.
But I want continuous rank based on each dimension selection.
When I am not selecting Month Id reports looks good. But when selecting any dimension like Month id its not showing desired result.
Which of the two isn't working? XY or Y?
Both of them
Would you be able to share a sample where we can see the issue.... and also if you can share the output you expect to see based on the selection... then that would be great