Forum Discussion
robertosangi
Helper I
4 years agoRanking values comparing two weeks
Hi, I have one question regarding the possibility to rank values based on a comparison between weeks. Here the problem: I have this kind of table: First of all i want to have first ...
- 4 years ago
Seems is not working anyway johnt75
Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure
Could you please rewrite formulas as you expected? Thanks
johnt75
Super User
4 years agoYou need the RANKX functions to work over the UT table, not the Date table
robertosangi
Helper I
4 years agoSeems is not working anyway johnt75
Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure
Could you please rewrite formulas as you expected? Thanks