Pivot table requirement

[panipat1990]

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

[sunny_talwar]

This?

Script:

Table:

CrossTable(Particulars, Value)

LOAD Code,

     Net_Rev,

     [Selling Expense]

FROM

[Data (6).xlsx]

(ooxml, embedded labels, table is Sheet1);