Cross Table problem

[GraceGao]

Hi Experts,

Is below format excel data can cross table to 2 dimension table structure?  Thanks.

  -------------->   Year, Quantity, Sales

[Wlad_Masi]

Hi @GraceGao,

Here is how to use crosstable function/wizard. I hope it helps.

Help - Crosstable
Unpivoting crosstable data in data manager - Qlik Sense

[Wlad_Masi]

Hi @GraceGao  did my comment help you?
Please let us from Community know.

[Saravanan_Desingh]

May be like this. Year and Header are Dimensions.

Year	Header	Value
2019	Quantity	100
2019	Sales	1000
2020	Quantity	200
2020	Sales	1500