Thanks in advance, experts!!!!! What I have:
2 worksheets in same Excel file, each has a table (Table1 on WS1, Table2 on WS2) with the SAME headers/type of data. As an example (only), BOTH tables have: Invoice# Cat1Sales Cat2Sales Cat3Sales TotalSales The only difference is that Table1 has this info for a single customer, Table2 has the info for multiple other customers. I would like to be able to bring it all into a pivot table (and have a chart) that will allow me to filter and calculate % differences between Table1 and Table2. For instance: Table1 shows that Cat1Sales make up 30% of all sales in the table (Cat2Sales 50%, Cat3Sales 20%), but for other customers (Table2), Cat1Sales make up 50% of all sales (Cat2Sales 10%, Cat3Sales 40%). This will show the customer how their purchasing direction varies from other customers', and maybe help them change their buying habits for more success. I would love to attach my existing file, but I can't seem to figure that out either... Thanks again for helping!!!!!!!! -- ---------------------------------------------------------------------------------- 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