Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Please help me to apply filter in pivot table on expression by using input box for minimum and maximum range.
Add an input box to your sheet and create two variables for it, for example vMin and vMax. Set the contraints to limit the possible input for the variables to one of the numeric option. Change the expression in your pivot table to make use of the variables. For example sum(Sales) could become sum({<QuantityOrdered={'>=$(vMin)<=$(vMax)'}>}Sales).