Forum Discussion

robertosangi's avatar
robertosangi
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
4 years ago

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

 

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