Do you know how to enable the "Total Mode" options in the Expressions tab?
I need to change them, but it appears gray and I can't use it.
I think u have taken the chart type as pivot table.
Change the Chart type pivot table to straight table at General Tab and u will get "Total Mode" active.
Thank you for your response. Do you know if there is any way to get the total only in some columns in a pivot table?
I know one work-around for it.
Right click on the cell which you dont want to display the total and "Custom Format Cell"
Change the text color to background color.
Not an ideal solution though!!!
Retrieving data ...