Is there a way to have a sum/count/grouping as the "values for new columns" within the Cross Tab tool? Say for this example my data looked like this:
I want Asset and Liability to become headers (like phone number 1 and phone number 2) and then I want to sum the Market Values grouped by Classification and count the number of Record IDs grouped by Classification. Can I do this using a combination of this cross tab tool and a summarize tool? Ideally I would want it to look like the pivot table in excel below.
