Changing Sequence of Dimension & Expression

[abeyphilip]

Hi,

Is it possible to put dimension in between expressions. For e.g.I have a pivot table with 3 dimensions and 5 expressions.

DIM1

DIM2

DIM3

EXP1

EXP2

EXP3

EXP4

EXP5

In the pivot table, can I have this sequence; (the order in which they appear in the table):

DIM1

EXP1

EXP2

EXP3

DIM2

DIM3

EXP4

EXP5

We have to stick with this sequence because the excel extract from this report is used as an input to another system which expects the order of the fields to be like this.

Thanks,

Abey

[sparur]

As I remember, you can't do it with Pivot. but it's possible with straight table chart.