RayRay_H Member

https://community-forums.domo.com/main/discussion/comment/93514#Comment_93514 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.

https://community-forums.domo.com/main/discussion/comment/77288#Comment_77288 My problem was solved by using Alter Column tile - Custom Date feature. I am still wondering why the formula doesn't work though .

https://community-forums.domo.com/main/discussion/comment/77380#Comment_77380 BTW, I am doing this in ETL not in Beastmode.

https://community-forums.domo.com/main/discussion/comment/77288#Comment_77288 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?

https://community-forums.domo.com/main/discussion/comment/69142#Comment_69142 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.

https://community-forums.domo.com/main/discussion/comment/69115#Comment_69115 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…