Pivot Formatting

[#1]

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

[Anonymous]

Not able to open....

Could you share your expected output? whta exactly you want?

[#3]

[Anonymous]

Again not able to open...

You can use Pivot Table to get similar output...

For these products which need to be like Column Fashion....Slicing & Dicing feature is avail

[PrashantSangle]

Hi,

Not able to open your excel

It is possible if

CampaignId, MappinID,Region,SubRegion,TotalQty,Covered %,No Of Pro,Total Product and Product is dimension

and

Gross Sales and Net Sales is Expression.

Regards

[#6]

If I do that it will divide other expression on the basis of product name,,

But I want that only gross divide on the basis of product name

[#7]

no

[Anonymous]

Well..Agreed as this is the default functionality in qlik.

Not sure whether we can achieve what you are asking for.

Lets wait for some more response, if this is possible

[kkkumar82]

Hi Shweta,

Try to create a inline load with 3 to 4 rows and create an Excel by your own, better it will help us.

Thanks

Kiran kumar

[sujeetsingh]

Why not you use custom format.

Plz come in more words