Ranking in cross tab across category group

[Hui Mien Lim]

hi,

I encountered an issue with rank in cross tab viz.

Rank is by Year& Quarter period by country sales. In the eample attached, Q1 is ranked correctly, however in Q2, the rank sorting is a bit off.Itis taking the rank in Q1.

Heres the expression used:

[QtrPeriod] as [Period] NESTDenseRank(Sum(CASE THEN [sALES] END) OVER ([Country]),"desc",[QtrPeriod]) as [RANK]NEST [Country]

Anyone able to help advise on this

 

Thanks

[Khushboo Rabadia]

It works at my end with sample dataset. Can you provide your dataset or dxp with sample data showing the behavior.