Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This?
Script:
Table:
CrossTable(Particulars, Value)
LOAD Code,
Net_Rev,
[Selling Expense]
FROM
[Data (6).xlsx]
(ooxml, embedded labels, table is Sheet1);