Apply Parameter/Filter to calculated field

Question & Answer
, , ,
1

Hi there,

I am trying to create a table where I can apply some filters per columns, e.g., I have column called “Companies” and it contains A-Z companies in it and another one with “Sales”. I want to create a column in visual called “Company in scope” and another called “Vs”. So the idea is to have controls on top, one that filters whatever I want to show in “Company in Scope” and another one that filters what goes in “Vs”, displaying sum(Sale) in the values of the table.

Does anyone has an idea of how can I create this calculated field?

Thank you!
Carlos

2

I think you’re looking for cascading filters.

1 Like
3

Thank you Max, I was able to create a cascading filter but I was able to only apply it to the entire visual, would you know how to make it work for only columns?

4

What would you like it to show when you filter only one column?

Would you like it to say Null or something?

1 Like