topic Re: How to filter and sum in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-filter-and-sum/m-p/2462015#M4456 <P>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!</P> Mon, 18 Apr 2022 17:45:54 GMT Anonymous 2022-04-18T17:45:54Z How to filter and sum https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-filter-and-sum/m-p/2447757#M4441 <P>Hi. Let say I have data like below:</P><P>Brand&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total</P><P>P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>P&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50</P><P>M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;25</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;20</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15</P><P>&nbsp;</P><P>How to filter the data and sum the total. For Example There are two P, and sum of total for both P are 30.</P><P>&nbsp;</P><P>Thanks</P> Sun, 10 Apr 2022 16:10:55 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-filter-and-sum/m-p/2447757#M4441 hafizro 2022-04-10T16:10:55Z Re: How to filter and sum https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-filter-and-sum/m-p/2462015#M4456 <P>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!</P> Mon, 18 Apr 2022 17:45:54 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-filter-and-sum/m-p/2462015#M4456 Anonymous 2022-04-18T17:45:54Z Re: How to filter and sum https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-filter-and-sum/m-p/2462033#M4457 <P>Hi, if I understood,</P><P><BR />You could put the data on a visual table and create a visual filter</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HenriqueReis_0-1650304967116.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/701253i03CD3712F59E4E4F/image-size/medium?v=v2&amp;px=400" role="button" title="HenriqueReis_0-1650304967116.png" alt="HenriqueReis_0-1650304967116.png" /></span></P><P>&nbsp;</P><P>On filter, you gonna set "brand" and after the specific data you want to see.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HenriqueReis_1-1650305251550.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/701255i6B93F3BBFABBA4B9/image-size/medium?v=v2&amp;px=400" role="button" title="HenriqueReis_1-1650305251550.png" alt="HenriqueReis_1-1650305251550.png" /></span></P><P>&nbsp;</P><P>Hope I help you!</P> Mon, 18 Apr 2022 18:08:03 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/How-to-filter-and-sum/m-p/2462033#M4457 HenriqueReis 2022-04-18T18:08:03Z