i have writen the code to gives me a pivot shown in ebere.xlsx but i need to be like signoff.xlsx. i found out that if a drag the summation value in the row field to colum field it gives me that , but how do i do that with code. thanks. if this is solved i will be able to convince my company to get aspose cos it is wonderful . just stumbled upon it 3days ago, never seem file format application so flexible like aspose for developers