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.
Try not to create duplicate thread for the same issue