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
It would be great if there was a way to take a table/slice, and create a dynamically changing pivot table view off the data.
- Dynamically updating the “columns” based on the data included in the pivot range.
As always, thanks for considering! (^_^)