HELP PLEASE - Add Subtotals into Mega Tables Domo

mamedu

Hi All, 

I have the following data:

 

Owner	Account	Amount
Randal	A	10
	A	10
	A	2
	A Subtotal	22
	B	3
	B	7
	B	9
	B Subtotal	19
	C	5
	C	10
	C	10
	C Subtotal	25
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

jaeW_at_Onyx

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.