This is a request from a researcher client of mine:
I would like to be able to take record-level data, and reorient it into a pivot table for further analysis.
Currently, the method to accomplish this is…
You have to create all sorts of specialize slices to hold subset of data, then tons of virtual columns to fill out the “columns” for the table - all of this virtual, running over tons of data, that will eventually become a nightmare to work with.
This “hack” of a way is not going to scale
As always, thanks for considering! (^_^)