Forum Discussion
Sum with multiple filters
Hi smoupre,
Thanks for your Input, for a detailed understanding pls check out my sample table where I have 7 unique records, but incase my record set increases to 1000 unique records and if I have to take a sum of few hundred rows of products it becomes difficult to hardcore every product for ex. =calculate(sum(value),filter('ProductsTable',products=A || 'ProductsTable',products=B || 'ProductsTable',products=x ......)
| Products | Value |
| A | 40 |
| B | 50 |
| X | 60 |
| Y | 70 |
| AA | 20 |
| BB | 30 |
| XX | 40 |
| YY | 50 |
Right, so what I am suggesting is that you put Products and Values into a table visualization or other visualization. Then, in the fields tab of the Visualization pane you click the drop down arrow on the Products field and click "New Group". This will allow you to group Products.
Alternatively, you create the table I described and create all of your groups there essentially. As long as your Products table has unique values for Products you could even have products in multiple groups. Relate the two tables on Products columns. You would then add your Group column from your Groups table and your Value column from your Products table and you would have your groups.