Sum functions for filtering

[Anonymous]

Hello,
I wanted to know, I have a table in Excel, in which there are Company and Currency columns, and there are drop-down menus with similar tabs, is it possible to configure a text label so that it displays sum for the selected company and currency?
Thanks in advance,
And best wishes.

[chrisog · Accepted solution]

Hi @Anonymous,

This should be simple enough. You will need to utilise a Switch formula to determine which currency column to return but it is simple enough.

Set the Text property of the label to:

Sum(Filter(ASK; Company = DropdownCompany.Selected.Company);Switch(DropdownCurrency.SelectedText, "USD", USD, "UAH", UAH, "EUR",EUR))

The way this works is that you provide the Sum function of your data source and then provide an expression - basically which column you want to evaluate - using the Switch function. The Switch functions works like a nested If but is easier to use with branching results like yours. It also lets you refer directly to column names. 

[Anonymous]

Thank you very much for your help))