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