How to Unmerge cells in Qlik Sense PIVOT chart table

[Icon_Arindam]

Hello Experts,

How can I unmerge dimension cells using  PIVOT table in  Qlik Sense 

Please help me to achieve this below format in Qlik Sense Pivot chart.

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

Thank you!

[TKOG]

Hi!

My language setting is Japanese.

The expression may be slightly different.

Select a pivot chart and
Please check the item of completely expand from style.

This will give you the display you need.