HELP PLEASE - Add Subtotals into Mega Tables Domo

Hi All, 


I have the following data:

 

OwnerAccountAmount
RandalA10
 A10
 A2
 A Subtotal22
 B3
 B7
 B9
 B Subtotal19
 C5
 C10
 C10
 C Subtotal25
Randal Total 66

 

I need to be able to show subtotal at both Owner & Account level all within 1 visualization. I'm able to show the subtotal at the Owner but I can't find a way to show using Account. I'm currently trying this with a megatable. Is there a way to show hierarchies within Domo? Can I show the 2 levels of subtotal?

 

Thanks

Tagged:

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    I'm pretty sure if you use the pivot table, it does have the ability to collapse nodes to give you the visualization you're looking for.

This discussion has been closed.