Help with calculate multiple column in the same table filtered by one of the column

Question

Dear All,&nbsp;&nbsp;I am having trouble calculating sum of coulmn by filtering two or more coulmn.&nbsp;&nbsp;In the below table I'm trying to calculate the the sales for any country from [Final Location] to sum 1st stop location and 2nd stop location based on the filter which matchs the [Final Location].&nbsp;Please ask me if it's not clear.&nbsp;DateSales&nbsp;1st stop location2nd stop location3rd stop locationFinal Location6/12/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,158DjiboutiSomaliaIndiaIndia7/2/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 525SomaliaTajikistanIndiaIndia7/8/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,415TajikistanIndiaIndiaSingapore7/22/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 215IndiaIndiaSingaporeThailand11/6/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 212IndiaIndiaThailandIndia6/12/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21,585IndiaBangladeshIndiaIndia7/2/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 899SingaporeHong KongIndiaIndia7/8/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 484ThailandIndiaIndiaIndia7/22/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,416IndiaIndiaIndiaIndia7/23/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 954IndiaIndiaIndiaIndia7/24/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,854BangladeshIndiaIndiaIndia7/25/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 658IndiaIndiaIndiaIndia7/26/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 254IndiaIndiaIndiaThailand7/27/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96Hong KongIndiaThailandSingapore7/28/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 411IndiaIndiaSingaporeDjibouti7/29/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 471IndiaIndiaDjiboutiSomalia7/30/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111Thailand&nbsp;SomaliaThailand7/31/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,001Singapore&nbsp;TajikistanIndia8/1/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 81Djibouti&nbsp;IndiaIndia8/2/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 945Somalia&nbsp;IndiaIndia8/3/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 894Tajikistan&nbsp;IndiaIndia8/4/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 525India&nbsp;BangladeshIndia8/5/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,415India&nbsp;Hong KongIndia8/6/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 215India&nbsp;IndiaIndia8/7/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 212Bangladesh&nbsp;IndiaIndia8/8/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21,585Hong Kong&nbsp;India&nbsp;8/9/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 899India&nbsp;India&nbsp;8/10/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 484India&nbsp;&nbsp;&nbsp;8/11/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 485India&nbsp;&nbsp;&nbsp;8/12/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 486India&nbsp;&nbsp;&nbsp;8/13/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 487India&nbsp;&nbsp;&nbsp;8/14/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 555India&nbsp;&nbsp;&nbsp;8/15/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 489India&nbsp;&nbsp;&nbsp;8/16/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,561India&nbsp;&nbsp;&nbsp;8/17/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 491India&nbsp;&nbsp;&nbsp;8/18/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 492India&nbsp;&nbsp;&nbsp;8/19/2019&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 484India&nbsp;&nbsp;&nbsp;&nbsp;Expected Result:&nbsp;&nbsp;Estimatedlocationsales sum of 1st stopsales sum of 2st stopIndia&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21,584&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25,415Somalia&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,521&nbsp;$&nbsp;&nbsp;687&nbsp;Thanks!

v-piga-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
I still have a little confused about your logic based on your data sample and your expected output.
If it is convenient, could you make an example for&nbsp;sales sum of 1st stop so that we could help further on it?
In addition, what is the location column from in your expected result?
Best&nbsp; Regards,
Cherry
&nbsp;

anonymous · Answer

I apologize for the confusion. Please refer to the explaination below:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;v-piga-msft&nbsp;Thank you,

Forum Discussion

Help with calculate multiple column in the same table filtered by one of the column

2 Replies

Related content

CALCULATE with multiple filters

Calculating with Filters

Calculate Filters

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

Calculate and filter using multiple tables

Date	Sales	1st stop location	2nd stop location	3rd stop location	Final Location
6/12/2019	$ 2,158	Djibouti	Somalia	India	India
7/2/2019	$ 525	Somalia	Tajikistan	India	India
7/8/2019	$ 2,415	Tajikistan	India	India	Singapore
7/22/2019	$ 215	India	India	Singapore	Thailand
11/6/2019	$ 212	India	India	Thailand	India
6/12/2019	$ 21,585	India	Bangladesh	India	India
7/2/2019	$ 899	Singapore	Hong Kong	India	India
7/8/2019	$ 484	Thailand	India	India	India
7/22/2019	$ 5,416	India	India	India	India
7/23/2019	$ 954	India	India	India	India
7/24/2019	$ 7,854	Bangladesh	India	India	India
7/25/2019	$ 658	India	India	India	India
7/26/2019	$ 254	India	India	India	Thailand
7/27/2019	$ 96	Hong Kong	India	Thailand	Singapore
7/28/2019	$ 411	India	India	Singapore	Djibouti
7/29/2019	$ 471	India	India	Djibouti	Somalia
7/30/2019	$ 111	Thailand		Somalia	Thailand
7/31/2019	$ 1,001	Singapore		Tajikistan	India
8/1/2019	$ 81	Djibouti		India	India
8/2/2019	$ 945	Somalia		India	India
8/3/2019	$ 894	Tajikistan		India	India
8/4/2019	$ 525	India		Bangladesh	India
8/5/2019	$ 2,415	India		Hong Kong	India
8/6/2019	$ 215	India		India	India
8/7/2019	$ 212	Bangladesh		India	India
8/8/2019	$ 21,585	Hong Kong		India
8/9/2019	$ 899	India		India
8/10/2019	$ 484	India
8/11/2019	$ 485	India
8/12/2019	$ 486	India
8/13/2019	$ 487	India
8/14/2019	$ 555	India
8/15/2019	$ 489	India
8/16/2019	$ 1,561	India
8/17/2019	$ 491	India
8/18/2019	$ 492	India
8/19/2019	$ 484	India

Estimated
location	sales sum of 1st stop	sales sum of 2st stop
India	$ 21,584	$ 25,415
Somalia	$ 6,521	$ 687