How to filter and sum

Question

Hi. Let say I have data like below:Brand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TotalP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;25C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;20D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;How to filter the data and sum the total. For Example There are two P, and sum of total for both P are 30.&nbsp;Thanks

anonymous · Answer

Hi, are you attempting to do this for a visual or to manipulate the data? For a visual, grab a spreadsheet for example and bring in brand then total. Select that the total is a sum. Logically, this is a group by. This combination should apply to multiple visuals. Let me know if you have any more specific questions!

henriquereis · Answer

Hi, if I understood,You could put the data on a visual table and create a visual filter&nbsp;&nbsp;On filter, you gonna set "brand" and after the specific data you want to see.&nbsp;Hope I help you!

Forum Discussion

How to filter and sum

2 Replies

Related content

Filter

Dynamic Filter

Inverse Filter

Override filters

Filter on Icons ?