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

IanMaddrell Member
edited February 2023 in Other Ideas



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.






This discussion has been closed.