Any reason why on a pivot chart table, all my expressions have their 'Total Mode' area grayed out? I need to modify the total since it does not sum all the rows in the column appropriately.
You have to dismark the total mode in the Chart Properties > Expressions >, you can choose which expressions are going to have their opwn Sum or which ones are not going to have their sum.
Pivot tables have more complicated totals than regular charts. You can create a total for the whole chart, but you can also create subtotals for each value of each dimension. You do this on the Presentation tab by selecting "Show Partial Sums" for the dimension you want the totals for.
It sounds like you've already selected to show partial sums, but aren't getting the totals you wanted?
Unfortunately, there's no "Total Mode" on that tab. So if you want to do something different than the default, you actually have to code it up carefully in the expression itself. This isn't always difficult, but it certainly CAN be difficult. We'll need more information about what you're doing and what results you want to see if you need help coding up the expression.
