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.


    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"
This discussion has been closed.