Pivot table date dimension sorting

[rdsuperlike]

Hi,

I see this issue in my pivot table that the dates are not getting sorted. I can see june data then august and then some july data and then again august. Instead i want to see them sorted from june to sept.

I don't know why is this happening.

I have attached the screenshot.

Ny help is appreciated.

[Anonymous]

You have to define sort order.  In this case it is a cycle group, so you have to do it with that group settings.

[rdsuperlike]

can u give an example?

[Anonymous · Accepted solution]

Go to Document Properties - Groups, select your group, click Edit button, and in Group Settings, select field on the left and click Sort Orders.  Sort by numeric.

[rdsuperlike]

I had one more question. In the cyclic groups i have daily date and week end date. and i am using that group in 2 different pivot tables.

But when i change to weekend dt in one table, I can see the change happening in another pivot table too. is there a way to avoid it?

either it is default or there is some small setting that needs to be changed that i am not able to figure out.

[Anonymous]

I think that it is quite a reasonable behavior .  But if you have to make them independent, you need to create separate cyclic groups - same fields, same settings, different group names,