Domo Beast mode row aggregation
Hopefully, you can help me!
I have a table like the enclosed one, which is based on a huge file, with the help of ETL I was able to reduce the complexity to this level.
My problem is that I can´t aggregate each day to one row. The aggregation is based on the filter.
So, when I want to see salesfigure for all platforms and all productgroups, there only should be one row with an aggregation of the sales figures 1 to 3.
If I won´t to check platform 1+2 and sales for product group 2+3, there only should be 1 row per day, if anysales happend.
Unfortunately, I was not able to find a good solution for my problem, perhaps someone knows a smart one!