Pivot table requirement

panipat1990 — Wed, 23 Mar 2016 20:48:34 GMT

Hi Team,

i have one requirement which i have to show in pivot table. please help me on this.

for reference , i have attached screen shot for the same and raw data in spreadsheet document.

In that screen shot, Table-1 we have raw data. and on the right-hand side pivot table is our requirement and we need to achieve it on front-end side if possible.

In Pivot Table, Formula for Net_Realisation is = Sum(Net_Rev)-Sum(Selling Expense)

Thanks

Gourav

Re: Pivot table requirement

sunny_talwar — Wed, 23 Mar 2016 21:05:05 GMT

This?

Script:

Table:

CrossTable(Particulars, Value)

LOAD Code,

Net_Rev,

[Selling Expense]

FROM

[Data (6).xlsx]

(ooxml, embedded labels, table is Sheet1);

topic Pivot table requirement in QlikView

Pivot table requirement

Re: Pivot table requirement