Excel Sheet Summary/Pivot with More than one Column in same Row

[gselvam]

In my data- imported from GP system,
we have
Customer Number, Cusotmer Name, Bill Number, Bill Amount,

Each customer is having multiple rows with differnt bill No, Bill amount.



But we want each customer wise what is total Bill amount along with Cusotmer Number & Customer Name.

To do this, we did PIVOT SUmmary, We got Customer Number & Total AMount -
But how to add Custmer Name also in the same row?

If I add in PiVOR Customer name is coming in next rows.. ANy hlpe for this ?

 

[sheetspread]

Change the layout from outline to tabular and remove the subtotals if you want

 

[gselvam]

Thanks Boss... This is exactly I am looking...