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 -- ---------------------------------------------------------------------------------- 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
Pivot-Question.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
