This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
I believe this will give you what you want. It sounds like you know how the crosstab and summary tools work just weren't able to figure out the combination. Let me know if you have any questions though and I can explain what's going on or if you need something different.