Do not require grouping in Pivot table

[agni_gold]

Hi Friends,

I have a situation, I  have one pivot table with multiple dimensions and 1 expression, and I have also done pivoting in that table, but the requirement is,

we want to pivot but not a grouping of dimensions values they should repeat like a straight table.

[vinieme12]

You just need to add the prevailing dimension to the next one

for example

Dim1

Dim2 & chr(10) & Dim1

Dim3 & chr(10) & Dim2

Dim4 & chr(10) & Dim3

and so on....

[agni_gold]

it will look like straight table ?

[vinieme12]

post a sample

[vinieme12]

correction it has to be the other way round

You just need to add the prevailing dimension to the next one

for example

Dim1 & Chr(10) & Dim2

Dim2 & chr(10) & Dim3

Dim3 & chr(10) & Dim4

Dim4 & Chr(10) & Dim5

Dim5

and so on....

[agni_gold]

First Column values should repeat.

[tresesco]

Try creating a Key field in the script like:

Autonumber(Country&State) as Key

and then a calculated dimension :

=Dual(Country, Key)

[agni_gold]

and if i have more than 2 dimensions in table then i need to create individual keys for each dimensions ?

[vinieme12]

No just create create a composite key with all possible fields that you will be using in the dimension

Autonumbrr (Dim1 &...........)

[tresesco]

You have to create/find a numeric key for all dimensions that you want ungroup in the chart. And you have to careful about using this key combination since they composite key order would decide your aggregation as well.