I am hoping someone could help me with creating a pivot table in Excel.
I have a list of associations (4), that host tradeshows (10), cost associations with each tradeshow, month they happen and a total for the cost.
I would like to have a pivot table that lists these left to right in the order above AND show the cost in the correct month. I have attached a sample Excel file illustration how i would like it laid out. Where I can expand/sort by association and/or tradeshows and/or costs.
If you need more information, please let me know .... I might not be giving you all that you need.
Seems like for that to work the costs (and corresponding data) would need transposed so costs are listed in a column similar to months. It's certainly possible but I'm not sure exactly how it would work while maintaining the connection to months. I'm having similar cognitive issues with it this late. Pivot tables certainly can be powerful but a PITA to get set up correctly.
All content owned by CycloneFanatic.com - All rights reserved 2005-09. By viewing this website you agree to the Terms of Service, Site Rules and Legal Disclaimer. The words, views, images and opinions expressed or provided by users do not reflect the opinions or views of CycloneFanatic.com or Iowa State University. The names, words, symbols, and graphics representing Iowa State University are trademarks and copyrights of the University protected by the trademark and copyright laws of the United States of America and other countries and are used on this web site under license from the University. Original site design, premise & construction by Jeremy Lind.