Unmerge cells in pivot table

[simonagheo]

Hello,

How can I unmerge dimension cells in pivot table?

Thank you!

[simonagheo]

My pivot table looks like this:

Account	Line	1	2	3
1	1	100	100	100
	2	200	100	200
	3	300	200	100
2	1	100	100	200
	2	500	300	100
	3	200	100	300

and I need it to be like:

Account	Line	1	2	3
1	1	100	100	100
1	2	200	100	200
1	3	300	200	100
2	1	100	100	200
2	2	500	300	100
2	3	200	100	300

Any ideas?

[sunny_talwar]

Use straight table with three expressions rather than using the pivot table because I don't think pivot table will allow you to do what you are trying to achieve here

[simonagheo]

The problem is that I need a horizontal dimension called period (with values: 1,2,3.....) like in the above example, and I don't know how to do this in straight table.

[ceciliafujita]

Hi,
Did you find out how to do it?

[manish_gupta]

Hello All,

did anyone find the solution for this in Qliksense ?

Thank you