Not sure why I'm getting this error, the results tab shows the data from the input anchor of the Table tool. Trying to generate a pivot table to print off. I did use cross tab tool prior so meets the requirements from the Table mode radio button up top. This is using sample data but my real data would be summing money values grouped on two fields.
I can essentially create the pivot table with a Summarize Tool and Basic Table but I want a "Grand Total" just like a regular pivot table.
@jsun_06 , The column names don't match. In the results tab, the column is called Total, in the table tool it is called TotCol.
@terry10 , Thank you for noticing this. I changed the column name with the Select Tool but still get the same error.
Could you attach a packaged workflow? It's hard to troubleshoot from a screen shot.