crosstable dataProblem

[nareshthavidishetty]

hi all please any one help me on cross table 

im attaching my excel file plz let me know

[nareshthavidishetty]

Please anyone help me on this data how to load

[Vengatesh]

How do you want to display your data? What are the Field Names? Provide some sample output you want.

[nareshthavidishetty]

thanks for the reply i want my o/p like
CA1 under that Main ,tirupathi i dont need total and sub total
Ca2 under that Lang,Shah etc and their related amount row so like mother child
Ca1 --- main----amount
ca1----tirupathi----amount what ever the amount is their
ca2 ---- lang----
ca2---shah---

[nareshthavidishetty]

anyone plz help me on this

[Anil_Babu_Samineni]

For sure, you need to manipulate in excel itself. If you really want that in Qlik side (May be code extended), Perhaps attachment helps. Make sure, this should work same in Qliksense too.

[Vengatesh]

As far as I know, you need to do some cleansing in Excel itself.  then with help of mapping load you can achieve this.

Find the attached Excel and QVW

[nareshthavidishetty]

thanks for the reply i will try and let you know

[nareshthavidishetty]

thanks for the reply,i will ask my  data team to clean