Alternate Sunday

[Former Member]

Hello,

How do we create a dimension/measure to calculate alternate Sundays in IDT?

Thanks

xxx

[former_member193866]

Hi Mo Mo,

Try below query...

select day_of_week_name,business_date,ROW_NUMBER() over (order by business_date) row_num,(ROW_NUMBER() over (order by business_date)%2) as "%"

from calendar where fiscal_year = 2016 and day_of_week_name = 'sunday'

order by business_date

Regards,