Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field called FECRSA with dates which is used as a filter list. I also have a pivot table which change according to the date selected in FECRSA. I would like to filter the pivot table with all the dates <= than the selected FECRSA. I suppose I have to need a variable and some way write in the filter list let FECRSA<=variable. How to get this?
Thanks
Add a Select in Field action to the OnInput trigger of the variable. Use FECRSA as field and as search string ='<=' & variablenamehere
edit: see attached updated qvw
I'm sorry but I don't understand, I attached a file.
So far, I'm trying to filter the main pivot table by the field 'FECRSA' being FECRSA<=CORTE. Being CORTE a variable choosed with an input box object.