Cannot produce a summation of values of a particular column

Ankan Chanda

Content

Hi team,

 

      I have created a pivot table consisting of attributes and values as percentage, in which I want to calculate grand total of values of a particular column by right clicking on that row/column and clicking on 'Show Total'. But here as I am right clicking on the row , the 'Show Total' is not being displayed. Hence , I am unable to calculate the summation of the values. I have uploaded an image of it. 

Please suggest me how to get through this or are there any other alternatives.

 

Thanks

 

Ankan

Wayne Van Sluys11111

Setting Totals on columns and rows is done in the properties panel

Joshua C. Stewart

You may need to add columns as part of the Summation values. Additionally, OAC might not allow a summation across the columns because of the column types. It looks like you're summing ratio's which can result in unexpected values.