Cyclic groups as Pivot table makes the dimension data jump around - Sorting

[EmiliaP]

Hi!

I have a issue where the dimensions of a pivot table just jumps around and I cannot sort the data according to demands.

I would like to sort it ascending (not any rocket science there), but when I add multiple levels of groups the data does not apply to the rules. What am I missing?

[StarinieriG · Accepted solution]

Hi,

I am not sure, but...like file attached?

[EmiliaP]

Holy my.. I've really been staring myself blind!

Huge tank you!

[Ksrinivasan]

Hi,

i have taken sample data wrt. your fields

FOR PIVOT  Dimension, Column, Measure as below:

result will be below:

i think its help to solve your prob......

K. Srinivasan.