Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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....
it will look like straight table ?
post a sample
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....
First Column values should repeat.
Try creating a Key field in the script like:
Autonumber(Country&State) as Key
and then a calculated dimension :
=Dual(Country, Key)
and if i have more than 2 dimensions in table then i need to create individual keys for each dimensions ?
No just create create a composite key with all possible fields that you will be using in the dimension
Autonumbrr (Dim1 &...........)
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.