Pivot Table for specific fileds on a table

Sample.xls

HI Guys..

I need your assistance in aut poopulating the the Pivot Table as per my requirement.

Pleasee see the attached file has a sample data(In Put sheet) and the my requirement of pivot is on the output sheet.

We are making this report manually, since the Pvit also not working( im unsure whether im not aware to prepare pivot liek this)

Please have a look and help me out.

PS: Im using excel 2010.

Thank you,
Safi.

Hi BaluSrinivas,

No solution yet, i need a solution sooner but i can wait 2 days.

Thanks,
Safi.