Pivot Table to show values on a row as opposed to a columns

IanMaddrell

Hi

 

With regards to pivot tables. In Excel you can pivot the value to show this as a row or a column. But the option on a Domo Pivot Table card forces the user to create all of the measures as columns.

 

Here is my scenario, I have targets as a beast mode for each region. I want to pivot a table by region as columns and measures as a group of rows for each measure, to show the actual performance and then the target as a group as a row grouped by each measure.

 

I have attached an example from Excel of what I mean. I really cannot see anyway of achieving this with the current Pivot Table card.

 

Thanks

Ian

Excel Pivot 1.PNG

Excel Pivot.PNG

jaeW_at_Onyx

I covered this topic a while back.

https://www.youtube.com/watch?v=YgevJkjeFqw&t=1s

 

Basically you need to structure your data 'the right way'.  

It's a bit of a hack but pretty flexible!