Unable to create grand total column-wise

[db89]

Hi All,

I have used the Reporting tool to get a particular formatted table. However, after getting the format with the numeric in 'Double' format in each column, the Summarize tool is not giving a column wise total at the bottom, although the configuration seemed to be fine. 

I have attached the screenshots for reference. 

Any guidance on this will be super helpful. 

[aatalai]

@db89 I'd recommend calulating totals before using the reporting tools. Also, the crew macros can help calculate totals http://www.chaosreignswithin.com/p/macros.html

[Qiu]

@db89 
The feature you are trying to use with Summarize tool may not be a good fit.

For column total or row toal, the combination of Transpose and CrossTab would be good, to my expierence.