• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

subtotal function using sum of numbers & concatenate text possible

Vijayv

New Member
Please solve my query I attched class file in tho sheets are there
In wich one is rawdata or input
Second is I want output
Kindly help me
 

Attachments

  • i want solution - suggestion in Pivot.xlsx
    26.5 KB · Views: 4
I modifed your PT to match your output, with a total generated for challan no.
 

Attachments

  • PivotExample.xlsx
    28.5 KB · Views: 8
Thank u for Reply with file
But in total raw data sum is appearing but name & date feilds are blank
For example in name feild data like ABC,xyz is it possible
Sorry for typing mistake
 
Back
Top