Hi, I just checked your file. You need to do a few modifications to your pivot. 1) Click on pivot table. Select Options and make Field List visible. It's the option on top right in Option tab. Remove Insurance , Claims and Reinsurance for Colum Labels. 2) Drag insurance in the sum Values area (right below Column Lables in field list to the right of row lables). Similarly drag Claims and Reinsurance to the same area. 3) Default they would be showing Count of Insurance, Count of Claims and Count of Reinsurance. Right click on any of them and select Field Settings. Select Summarize by Sum. Now the field sum would be shown in the table as you need it.
In case you have trouble understanding or implementing the solution feel free to reach me at anandydr at gmail dot com. Hope that helps, Anand Kumar. On Jan 26, 10:01 pm, Pavan Kumar VVN <nagapavan....@gmail.com> wrote: > Hi, > > I have a testing scenario where I have Severity (Critical, High, Medium & > Low) and I have modules as Insurance, Claims, etc. When I take a pivot, I > want to combine all the module information in the body of the pivot showing > Severity in Row labels and all the other info under summation of Total of > Insurance, Claims, etc. I do not have a total column in my data sheet. Can > someone help. Attached is some data related to this. > > -- > V.V.N. Pavan Kumar > > Pivot-Question.xlsx > 16KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel