Forum Discussion

wilson_smyth's avatar
wilson_smyth
Post Patron
8 years ago
Solved

unexpected crossjoin in table

Hi. Im performing a ranking against Posts so we can identify top and bottom posts. It works ok, until I add the Center in which the post resides.   At this point, it looks like a crossjoin occu...
Need Help
  • FarhanAhmed1984's avatar
    FarhanAhmed1984
    8 years ago

    Hi Wilson,

     

    Can you please try this in ranking function.

     

     

    Rank of Location = IF([Sum of Value]=BLANK(),BLANK(),rankx(all(Location), [Sum of Value],,DESC,Dense))

     

     

FarhanAhmed1984's avatar
FarhanAhmed1984
Resolver III
8 years ago

Hi Wilson,

 

Can you please try this in ranking function.

 

 

Rank of Location = IF([Sum of Value]=BLANK(),BLANK(),rankx(all(Location), [Sum of Value],,DESC,Dense))

 

 

  • wilson_smyth's avatar
    wilson_smyth
    Post Patron
    8 years ago

    Thank you Farhan, that worked!

    Could i ask for the correct reason why this worked? It would be good to understand whats going on under the hood here.