Cross Table Issue

[jyothish8807]

Hello Friends,

I need you help in converting the table in the attached excel in to cross table.

Mentioned below is my required output. Also in a separate text box i want the max(first row) ie. 1 in my case. (See the attachment). This is a dynamic file and data keeps coming in.

  Thanks in advance.

Output:
BRAND	Week	Sale1	Sale2
A	W1	12	32
A	W1	23	54
B	W2	34	43
B	W2	32	44

Regards

KC

[Kushal_Chawda]

First row would be 0,1,2,3.. sequential?

[jyothish8807]

Yes Kush, it will be sequential

Regards

KC

[jyothish8807]

Any help guys

[settu_periasamy]

Hi,

I tried with this multi_header_pivot_import.qvw

[sunny_talwar]

May be explore this qvw by Gysbert -> multi_header_pivot_import.qvw

[gerry_hdm]

use  generic

Gruß Gerry