Filtering names in Table

[jayesh179]

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

[jwjackso · Accepted solution]

You can limit the companies in the sum function.

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

Suppress zeroes.

[jayesh179 · Accepted solution]

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..

[jwjackso]

Look at the ValueList  function to create a calculated dimension.