The table I am using consists of many levels for instance cell D15 is the sum of cells D16:17, D17 is the sum of D18:19 and D19 is the sum of D20 (the file is attached). So basically I have several summary tabs, but I am wondering is there a way to create a table that does this automatically? More specifically can I assign a summary row and it automatically knows the cells following add up to that particular row based on the text being tabbed over or any other criteria (similar to Microsoft Project)? If this is possible, can I create a multiple combination pivot chart to reflect this information? I want a pivot chart that reflects the total dollar amount AND the percentage of the total dollar amount provided. I haven't added the percentages in the file I attached; however, each column with a dollar value will have a column next to it reflecting the percentage of the total (I also have not included a total column). I want a line and bar graph combination. Thanks in advance
Bookmarks