I've searched around but haven't had any luck finding what I need, but I am not sure if I've searched the best way either so please refer me if this is a duplicate.
I'll use dummy data to ask my question, but effectively I need the difference between two values across a couple of dimensions. The goal is different from our own data but the formulas needed are the exact same.
Attached is the excel for my dummy data. Basically, the data is sellers with the number of sales they had in a state during some year. The pivot tab has the sellers broken out by each state with the difference of the sales from one year vs the previous year.
The goal is to determine how many more sales they are from breaking even with their previous year's performance. We can see that Gandalf and Obi-wan need 4 and 5 more sales respectively within Texas, whereas Tyrion has already broken even (well technically no sales in Texas but you get the idea).
While this is possible in excel and is currently being utilized, I would prefer to use Domo to visualize a similar setup.
I can't get a difference in the beast mode since the data has to be aggregated across multiple rows and making an ETL for this is doable but I wanted to get the community's take before I go down that route, which seems less flexible for drill-downs.
I can set up a pivot in Domo but the value field is preset aggregations and there doesn't appear to be any custom calc for values.
Any ideas?