Forum Discussion

robertosangi's avatar
robertosangi
Helper I
4 years ago
Solved

Ranking 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 ...
Need Help
  • robertosangi's avatar
    robertosangi
    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

     

robertosangi's avatar
robertosangi
Helper I
4 years ago

I solved the measurement problem. Only rank doesn't Work... Here the situation:

 

VIJAYKUMART's avatar
VIJAYKUMART
Resolver I
4 years ago
IF(
HASONEVALUE(
Table name (unita)
),
RANKX(
ALL(
table name of unita (unita)
),
pdlcurrentweek measure
)
)