Unable to create grand total column-wise

Question

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.

image.png

Qiu · Answer

@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.

aatalai · Answer

@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