topic Filtering names in Table in App Development

Filtering names in Table

jayesh179 — Sat, 16 Nov 2024 02:22:36 GMT

Sample table

Hello Friends

I am creating Table and in one of column, i want to list few selected names only(As this table in yellow), can anyone please help me, i tried lot but not successful

Re: Filtering names in Table

jwjackso — Wed, 20 May 2020 18:28:21 GMT

You can limit the companies in the sum function.

Sum({$<Company={'Alfa co','Beta co','Aron Inc'}>} Revenue)

Suppress zeroes.

Re: Filtering names in Table

jayesh179 — Wed, 20 May 2020 18:58:04 GMT

This helped actually, many thanks. one more question, how if i want put filter in name column ? i mean if i cant use "Sum" function and i dont have nos in my table..

Re: Filtering names in Table

jwjackso — Wed, 20 May 2020 19:07:10 GMT

Look at the ValueList function to create a calculated dimension.