Display Rank on two mesaures for Current Month and previous month in one table in Webi

[former_member729103]

My requirement is to display Top 10 Rank for Current Month and to show their corresponding Rank position in the Previous Month for the same dimension in one table in Webi 4.2.

I have applied Rank for Current Month, which shows correct data, but for previous month the rank only shows the result based on those 10 dimension data and does not Rank on the whole set of data for previous month.

eg. with Screenshot below

Any inputs will be highly appreciated!!

Thanks

[amitrathi239]

have you tried with nofilter() function on "rank-previous month" column?