Forum Discussion

Dinesh R's avatar
Dinesh R
Copper Contributor
Sep 28, 2018

Help in presenting data in pivot table

Hello Everyone   Please refer the attached file of excel, help me in presenting the data using Pivot Table according to my need.   Regards, Dinesh. R  
Excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Sep 28, 2018

Hell

 

Drag "GST" also into the row area.

 

  • Dinesh R's avatar
    Dinesh R
    Copper Contributor
    Sep 29, 2018

    Hi,


    Thank you for your reply.

    But i don't want the "GST" to be shown using row but i need it through values field only as i need it to be next to my vendor name & total amounts.


    In more simpler context i need a solution to "show what ever in in a cell as it is" even if i put it under "values" in the pivot table.


    See if you could help on this.


    Regards,

    Dinesh. R

Resources