I am using Sense and have a table (Option) with only field where the user must select his choice (Direct or Internet)
In this sheet I have a straight (can be Pivot) table that shows Sales data and I have to exclude some lines of this table based on the user choice.
Considering that Sales table has a field called Type_of_Sales with the same options (Direct or Internet). How can I make this filter, considering that I cannot put Type_of_Sales field direct to the user makes the selection?
sorry but it is not this my problem. Imagine that you have a straigh table that is not linked to this selection you made, but you need exclude some lines based on a second field that will have the same content that you selected in Dimension1. How would you do that?