Hi Phil,

Thx for the provided solution.

It works as expected but in order to work this part need to be hidden in the output "CONCAT(t1.TestSort, '.'"

So basically...

Hi Jeff,

My required output would look like this

So within each category the sort dense rank is sorted by Date. But the sorting needs to...

Hi Guru,

I need to have the same granularity in SortColumn as in Category.

So somehow sort the sort column by date within the same categories

The reason for this is that I...

Hi Mark,

Not really. As you can see in the attached Screen dump the Row_Number will index the same categories but it should be the opposite.