Cross Table

[apthansh]

Hi ,

I have attached file but this is not in a friendly format.I want to do cross table but not sure how to group 3 different elements.Any help is appreiated.

Basically I want the below fields

Location,

CC,

#OFSpots,

Contract,

MethodofPayment,(this should have all values(types & values(now its just X as place holder)) from column E to K)

SourceofRevenue,(this should have all values(types & values(now its just X as place holder))  from column L to R)

Expense Payed by client (this should have all values (types & values(now its just X as place holder)) from column S to W)

Thanks much,

Ansh.

[olivierrobin]

hello

for me, you have to put in dimensions

location,cc,#of spots, contract

horizontal dimensions method / Source/expenses

but i dépends on what data you have

[apthansh]

sunny‌t stalwar1‌ any thoughts please...you are my blessing always

[avinashelite]

check this thread

multi_header_pivot_import.qvw

[sunny_talwar]

May be look here

multi_header_pivot_import.qvw