Pivot table-Add one blank row

Reply
Highlighted
Green Belt

Pivot table-Add one blank row

Hi Team,

 

Is there any option or way to add a row heading and a blank row in pivot table. Something like as in attached screen shot, done for DB1 row and PRG row.

 

Thanks,

Neeti

Highlighted
Red Belt

Re: Pivot table-Add one blank row

EDIT:: https://youtu.be/YgevJkjeFqw  video showing how to do it.

 

 

To get it as a pivot table, I imagine you'd have to treat your 'headers' like you do hierearchies in Excel Pivot Tables.

 

For example if you wanted to see a grouping for Customers by State, you have Customer and State value on each row, and then can use a Group By.

 

Your screenshot is a little tough b/c it looks like your Row Axis are measures.  But you could have measures grouped by category assuming the granularity of your data was one row for each metric.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Build a profit in loss statement in #Domo using out of the box features. "Is there any option or way to add a row heading and a blank row in pivot table." My...
Highlighted
Green Belt

Re: Pivot table-Add one blank row

Hi @jaeW_at_Onyx ,

 

Thank you so much for the informative video. I am gonna follow this in my building activity.

 

My question was to have a blank colored row between the grouped values. As I have mentioned blue blank line against DB1 and orange blank line against PRG.

 

Could you please suggest me how we can add a BLANK line as given in my screen shot.

 

Thanks,

Neeti

Highlighted
Red Belt

Re: Pivot table-Add one blank row

Neeti, a blank row could just be a row with a space in it.  Add it to the Measures table I described.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.