Pivot Formatting

[#1]

How to create the pivot table in format defined in excel ,where only gross divide on the basis of product name

[#2]

how to do that, can u explain with an example

[kkkumar82]

My intension was to create a excel sheet with data in one sheet and in other sheet please define your format.

So that we can help you in Qlik.

Thanks

Kiran