Forum Discussion
Solved
Sum By Row
Hello! Need help with the correct approach to do the following. I have a table that looks like: Store State Product Sales A CA Apple 5 A CA Pear 1 A CA Orange 1 A C...
Hi shuberml
Create a table with category and product as below, then relate two tables with "product" column,
Add columns into matrix and select "sum" aggregation, set filters as below:
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you both! Used the second solution, but both were effective!