Pivot table with 'steady' months

[Anonymous]

Hi, I have a pivot table with various dimensions that can be put on/off by the user via buttons. The pivot table has one measure.

One of the dimensions is WEEKYEAR. I want this dimension always to be the first one.

So I want

                                                           Week 35-2016  30-2016 24-2016 22-2016 ...

Dim1  Dim2 Dim3 Dim4 Dim5..                            10         20        10         30          

However, when I let the user add dimensions, the sometimes appear above the week dimension, and that is not what I what. I already played arround with the order of the dimensions (promote-demote), but that doesn't solve it.

Any suggestions?

Het bericht is bewerkt door: Henk Leppers. I have added a simplified example. What I want is that no matter what dimensions are chosen via the buttons, the week dimension always has to stay on top (horizontal).

[agomes1971]

Hi,

please post a sample it's easier to understand the logic you want to implement.

Thanks

André Gomes

[MindaugasBacius]

In what scenarios do you get the week below the other dimensions? What dimensions are on/off?

[Anil_Babu_Samineni]

Is this you are expecting?

[Anonymous]

Yes Mindaugas, that's what I want. But sometimes when I push one of the dimension button, the WEEK dimension dissappears.

[Anonymous]

For example: when I push the Code button, the WEEK dimension is gone...