Help on Pivot Table

[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. 

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)

Please let me know if something else is needed.

Thanks

Gourav

[sunny_talwar]

Would you be able to share the same data in a Excel file or qvw file?

[panipat1990]

Hi Sunny, when i click on "Reply to original discussion" option then i am not able to find the option for attach any document.

Would appreciate Please guide me where i can attach the same excel file for the above requirement,

Thanks

Gourav

[Chanty4u]

U can open ur thread in new page.... it will look lik below.

top right on ur replay  as  "use advanced editor" select this    down u will find attach