I am new to this part of the MS Excel forum, so I hope there is a easy solution to this problem.
MS 2007 Excel
I have a pivot chart in a workbook. The data is on a separate sheet of the same workbook being feed externally through a connection to a MS Access database. The data portion is set to give me percentages and the chart to display the percentages of the data. No problem here.
What I want to do is also, display the sum of the data on the same sheet as the pivot chart. I can do this if I create another copy of the data to another sheet but this is messy and is not what I want.
Also, when I have %, I want to select 2 row criteria. When I do, because it is %, it gives me the % between the 2 row, not individually,....