I'm currently using cross tab, tables, and render tools in my workflow, but I can't figure out how to manipulate this data set into a pivot.
Attached are the raw input file and below is an image of the desired output I am trying to achieve.
@alteryxisconfusing the same use case discussed in the below weekly challenge
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-292-It-s-about-Pivoting-Prepping-and-Reporting/td-p/841274
Hi @alteryxisconfusing
One way of doing this
Is it possible to have it displayed in the Output in this manner? I don't need the row/column totals like in the image, just the data grouped accordingly by student name and then showing their associated class cost and expense. So it should output kind of like this:
Please take a look at the attached version.
Thank you so much, it works, is it possible to also pivot it to look like this?
