SUM And filter for barchart

[KhanhTNguyen]

I want to calculate the SUM estimation of work hour, filter by Month and customername based of Gallery to a BarChart

so far, I have this for legends and its working, ( The dropdown with Proper(Calendar.MonthsLong()) )
Distinct(Filter(Gallery4.AllItems, Periode = Dropdown2.Selected.Value), CustomerName)

BUT for the graph this dosen't work !
Sum(Filter(Gallery4.AllItems, Periode = Dropdown2.Selected.Value), ProjectTime)

[v-sheyu-msft · Accepted solution]

Hi @KhanhTNguyen ,

Could you show me the structure of your data source ?

What kind of chart do you use ?

Which property is the formula set to ?

I assume that you use Line chart control.

Do you want to show the Sum estimation of work hour in Line Chart ?

I have made a test.

I create a sharepoint list named test7. Periode column is single text type . CustomerName column is a single text type. ProjectTime is number type.

Set Items property of LineChart1 to :

{Title :"name1",value:Sum(Filter(Gallery1.AllItems,Periode =Dropdown1.Selected.Value),ProjectTime)}

Regards,

Eason

[KhanhTNguyen]

Hey Eason thanks you for helping me out, but my concern lie in the customername field in gallery due to fact that a customer"customername" can have more than 1 project.

I need to sum up the projectime based on periode and customername,

Best regard, 

Khanh