procentage of column based on category

[Anonymous]

I have two columns. One with values, eg. $750, and one with a category, either 1 or 2.

I want a graph with percentage of category 2 out of category 1. Procent=(sum of values of category 2)/(sum of values of category 2).

I have tried the following formula, but the graph is not dynamic 

Divide = DIVIDE(SUM(_17_Finanspost[2]);SUM(_17_Finanspost[1]))

Thanks for the help

[v-piga-msft]

Hi @Anonymous,

The sample from chirayuw should be useful.

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[Anonymous]

See Sample

https://ufile.io/ktimy

[Anonymous]

There is a problem with the procentage. It change when looking into the numbers.

[v-piga-msft]

Hi @Anonymous,

I'm still a little confused about your issue.

If it is convenient, could you share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[Anonymous]

I have created an exampel

The procentage decrease as i look more into the graph.

Date	Value	category
03-06-2018	9989	1
29-12-2017	9975	2
04-06-2018	9781	2
19-02-2018	9661	2
23-09-2017	9640	2
15-06-2018	9620	2
10-01-2018	9444	2
29-10-2017	9436	2
19-02-2018	9426	1
28-11-2017	9263	2
29-09-2017	9237	2
06-04-2018	9218	1
20-12-2017	9064	2
20-01-2018	9013	1
16-02-2018	8789	2
29-01-2018	8661	2
30-01-2018	8603	1
05-01-2018	8509	2
29-09-2017	8465	2
11-03-2018	8456	2
28-09-2017	8450	2
01-05-2018	8407	2
03-11-2017	8401	2
10-06-2018	8388	2
02-05-2018	8367	2
06-07-2018	8335	2
12-05-2018	8191	2
30-05-2018	8186	2
22-03-2018	8185	2
14-05-2018	8128	2
29-04-2018	8105	1
08-01-2018	8081	2
27-02-2018	7874	2
11-04-2018	7772	2
11-11-2017	7663	2
01-10-2017	7659	2
18-02-2018	7581	2
15-05-2018	7481	2
20-11-2017	7454	2
26-02-2018	7396	2
02-05-2018	7369	2
21-11-2017	7369	2
18-12-2017	7357	1
12-01-2018	7301	2
09-03-2018	7281	2
31-12-2017	7221	1
24-05-2018	7193	2
22-03-2018	7167	2
06-06-2018	7047	2
30-06-2018	6997	2
10-04-2018	6984	2
25-06-2018	6982	2
21-01-2018	6979	2
03-01-2018	6938	2
23-03-2018	6935	2
06-06-2018	6903	2
17-11-2017	6839	2
14-12-2017	6764	2
28-03-2018	6753	1
02-04-2018	6650	1
01-02-2018	6642	2
16-03-2018	6639	2
31-01-2018	6621	2
09-02-2018	6528	2
28-09-2017	6421	2
28-12-2017	6394	2
12-06-2018	6321	2
07-12-2017	6261	2
30-01-2018	6220	2
09-05-2018	6142	1
16-02-2018	6128	1
30-12-2017	6072	1
17-04-2018	6045	2
05-02-2018	5975	2
07-10-2017	5899	2
25-05-2018	5893	1
22-09-2017	5868	1
03-12-2017	5831	2
17-01-2018	5794	2
03-05-2018	5790	2
11-06-2018	5790	2
01-11-2017	5684	1
02-05-2018	5658	2
12-01-2018	5583	2
06-03-2018	5534	2
26-01-2018	5465	2
15-05-2018	5457	2
11-10-2017	5428	1
25-10-2017	5409	2
10-10-2017	5408	1
22-09-2017	5393	2
31-10-2017	5389	2
13-02-2018	5378	1
31-05-2018	5375	2
07-10-2017	5372	2
07-05-2018	5335	1
27-02-2018	5232	2
27-03-2018	5203	2
13-02-2018	5202	2
05-07-2018	5185	2
30-03-2018	5164	2
12-03-2018	5143	2
08-03-2018	5053	1
01-03-2018	5035	2
19-02-2018	5014	2
05-04-2018	4985	2
10-06-2018	4897	2
07-11-2017	4856	2
19-04-2018	4813	2
10-10-2017	4779	2
12-11-2017	4776	2
31-01-2018	4742	2
22-02-2018	4680	1
31-05-2018	4668	2
12-02-2018	4651	2
09-01-2018	4505	2
16-10-2017	4454	1
29-04-2018	4354	2
04-11-2017	4271	2
06-07-2018	4246	2
26-03-2018	4239	2
24-02-2018	4236	2
24-06-2018	4163	1
28-09-2017	4092	2
27-05-2018	4089	2
10-02-2018	4085	1
20-12-2017	4069	2
11-02-2018	4055	2
07-05-2018	4043	2
05-06-2018	4011	1
30-03-2018	4011	2
13-05-2018	3932	1
15-01-2018	3854	2
02-02-2018	3843	2
24-02-2018	3800	2
13-01-2018	3697	2
03-12-2017	3551	1
13-03-2018	3540	2
18-10-2017	3517	2
26-04-2018	3488	2
30-11-2017	3384	2
14-05-2018	3309	2
17-03-2018	3276	2
26-05-2018	3253	2
23-06-2018	3212	2
25-04-2018	3045	1
28-09-2017	3039	1
10-06-2018	3035	1
21-05-2018	2923	2
09-12-2017	2909	1
30-11-2017	2757	2
24-10-2017	2610	1
30-09-2017	2577	2
11-02-2018	2570	2
06-06-2018	2511	2
30-04-2018	2475	2
12-04-2018	2468	2
11-10-2017	2452	2
24-11-2017	2451	2
14-03-2018	2327	2
23-05-2018	2255	1
08-05-2018	2248	1
29-11-2017	2188	2
13-10-2017	2131	2
24-10-2017	2073	2
11-05-2018	1988	2
11-07-2018	1959	2
03-05-2018	1957	1
04-07-2018	1874	2
30-09-2017	1699	1
07-07-2018	1618	2
26-09-2017	1570	2
20-05-2018	1559	1
24-03-2018	1480	1
25-09-2017	1424	2
17-02-2018	1415	1
09-10-2017	1329	1
06-11-2017	1269	2
05-12-2017	1226	2
12-02-2018	1223	2
11-11-2017	1134	2
15-02-2018	1058	2
13-12-2017	1049	2
21-01-2018	1034	1
06-06-2018	966	2
06-07-2018	958	2
29-12-2017	941	2
01-10-2017	935	2
21-10-2017	923	2
18-11-2017	872	1
03-03-2018	848	2
24-12-2017	766	2
16-07-2018	755	2
17-10-2017	732	2
19-03-2018	630	2
27-05-2018	618	2
03-10-2017	613	2
14-02-2018	570	2
30-04-2018	522	2
21-06-2018	466	1
23-01-2018	460	1
27-05-2018	373	1
03-12-2017	360	2
04-11-2017	241	2
18-05-2018	231	1
13-05-2018	206	2
25-02-2018	191	2
10-04-2018	133	1
12-03-2018	117	1
09-12-2017	115	2
16-06-2018	89	2