RayRay_H Member

Thank you for your answer. I tried and I also can't make it work. Maybe this is a DOMO limitation.

@bryced Thank you very much for your comment and solution. The average works by adding both Day and Shop column in the fixed by function. However, both row subtotal and column subtotal are showing the average. Is there any way to have subtotal row as average but total column as the aggregated sum?

Thank you for your answer!

Thanks all for the answers and explanations.

My problem was solved by using Alter Column tile - Custom Date feature. I am still wondering why the formula doesn't work though .

BTW, I am doing this in ETL not in Beastmode.

Hi Michelle, Thank you very much for your help. After I tried your formula, the error message is still there:

Thanks all for the answers!

Thank you for sharing your way of achieving this. This is a good idea😄 but it seems this is one of the limitations of domo that domo can't put gross profit with all other totals/subtotals together on a same table?

Thank you very much for your explanation. I tried to use the Megatable transpose function but seems the total and subtotals are on the columns too, not on the rows.

Thank you for your comment. Yeah, beast mode can calculate gross profit easily but I don't know how to insert this Gross Profit just below the Total Cost of Sales without joining a second table. Just like the following excel table shows, another row of Gross Profit should be added into pivot table. If I add the Gross…