Currently pivot feature is available only in UI (via configureViewDataTable), while it would be great to also give such possibility in API. Very useful use-case would be to use such feature to allow row-evolution graphs for pivoted columns. Each label to plot would be another pivoted column. Also there could be "other" and "total" column to visualize how each of columns evolve.
Please let me know if this ticket description is sufficent or should I elaborate more on this concept ?
It's possible do pivot-ing in the API (otherwise the export functions wouldn't work w/ pivoted data). I don't know about row evolution w/ pivotted tables, though, I haven't tried that. If it does work, it will likely be slow.