Question

Ordering of pivoted columns

  • 30 June 2022
  • 0 replies
  • 132 views

Hi,

In Excel pivot table, it’s possible to reorder so that the pivoted column is nested under each values. e.g. in the above example, if i move the “Values” above “Is Offline”, I can see all the “Sum of Orders” by pivot, and then all the “Sum of payment” by pivot.

Is it possible in Looker? 

Also is there any easier way to drag and drop to re-order pivoted dimensions? Right now the method is to unselect everything and then re-pivot according to the desired ordering.

 

Thanks!


This topic has been closed for comments