Calculate sharepoint value by author

[AlanBo]

Hi, 

I've created a dropdown where i can select all authors from my sharepoint list
Distinct(datasource,author.displayname)

But then i want to sum a column from the list by the selected author.

Sum(Filter(datasource,dropdown1.selected.value),columnname)

I hope you can guide me in the righ direction.

Best regards

[v-xida-msft · Accepted solution]

Hi @AlanBo,

Could you please share more details about the data structure of your SP list?

Is the author a custom Person type column in your SP list or the System column?

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Dropdown control to following:

Distinct('20181122_case14','Created By'.DisplayName)

On your side, you should type:

Distinct(datasource, author.DisplayName)

Set the Text property of the Label control to following:

Sum(Filter('20181122_case14','Created By'.DisplayName=Dropdown1.Selected.Value),Amount)

On your side, you should type the following formula:

Sum(Filter(datasource, author.DisplayName = Dropdown1.Selected.Value), ColumnName)

More details about the Filter function, please check the following article:

Filter function

Best regards,

Kris

[AlanBo]

Thank you.

This works as expected.

To make it a bit more complicated, is there a way i can add a date picker to filter the amount greater than a specific date?