Dinamic Table with 3 headers

[Rodlibar]

Hi, I need to convert the table 1 to table 2 example. Is it possible we make that? 

Thanks in advance

Send DataSend Data

[JonnyPoole]

Its possible. Would take some time/iterations to do it. I would first restructure the 1st table into a table with only a single measure (IE: value) and more dimensions: Product, Num, Letters, OneSize, and a Classification field. Then you could create nested pivot table in the UI. 

Most of the iterations, logic would be in the load script to convert the table into the single measured table.

[Rodlibar]

Hi Jonny, thanks for reply.

Actually the first table is just the data visualization. We have here the data tables:

Send DataSend Data

[JonnyPoole · Accepted solution]

I don't see 'cap', 'one', or 'onesize' in that data set...  if possible supply the sample data in CSV, XLS, or TXT format including all values needed to replicate the pivot chart you shared above.

Also is this QlikView or Qlik Sense?

[Rodlibar]

Hi Jonny, please, check below the qlik sense file. 

Send DataSend Data