Sort Data

[QSense]

Hi everyone,

I have dimension below ISTEK_ACISTARIHI2 date format and its format dd.mm.yyyy hh:mm:ss

I want to sort data according to below expression

=day(weekstart(ISTEK_ACISTARIHI2))&' ' &monthname(weekstart(ISTEK_ACISTARIHI2))&'-' & day(weekend(ISTEK_ACISTARIHI2)) &' ' & monthname(weekend(ISTEK_ACISTARIHI2))

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

Ok, I see the problem. Your calculated dimension is creating a string. That can only be sorted alphabetically which is not what you want. I think you need to split that in two calculated dimensions.

Start week: =date(WeekStart(ISTEK_ACISTARIHI2),'DD MMM YYYY')

End week: =date(WeekEnd(ISTEK_ACISTARIHI2),'DD MMM YYYY')

After that you can sort Start week (and End week) by Numeric Value

[QSense]

Thank you man

It is ok

[QSense]

Hi Gysbert,

May ı ask something else?

Itis ok but in pivot table how to hide the colum you said ?

İn straight table I can hide .