Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to filter a list field if a criteria is met example:
list all the accounts where the Account Manager is Mr. White. I need to do that using a formula and not the normal filter Account Manager table.
Attached is an example excel file with the data included.
the requested is to show only the records from Mr. white as a list.
thank you for your help.
Not sure where you want to show this? List box? Try this list box expression
=Aggr(Only({1<[Account Manager] = {'Mr. White'}>}[Account Name]), [Account Name])
Not sure where you want to show this? List box? Try this list box expression
=Aggr(Only({1<[Account Manager] = {'Mr. White'}>}[Account Name]), [Account Name])
This worked, perfect
thanks a lot.
can we add another criteria to that? example account manager is Mr. White and Year Created equal 2016?
Yes you can:
=Aggr(Only({1<[Account Manager] = {'Mr. White'}, Year = {2016}>}[Account Name]), [Account Name])
Hi and thank you for your help as always,
i want in the list to show more than one project manager actually 4 of them, but the below is not working it is only showing Mr.Black:
Aggr(Only({$<[BI Project Manager] = {'Mr.White'}, [BI Project Manager] = {'Mr.Black'}>}[BI Project Manager]), [BI Project Manager])
how should i amend it to show both Mr.White and Mr.Black?
Try Aggr(Only({$<[BI Project Manager] = {'Mr.White','Mr.Black'}>}[BI Project Manager]), [BI Project Manager])