Hi,
I have a pivot table as below. Can I add a filter control for the column Product Type and in the filter control, the value “National average sales” is always selected. Because I want to make sure this is a reference value to set more context no matter what product type is filtered.
Or if there is another way to always keep the row of “National average sales” no matter what product type is selected in the filter control, that would achieve the same result.
Thank you very much!
Hello @luckymeow, what we can do is utilize an OR conditional in the filter you are applying to the pivot table to ensure that the one value you always want to return will remain in the options listed. Then, you can use the 2nd part of the filter to create the control that will allow the user to select from the dropdown options. It would look something like this:
First you would create a filter just to ensure the single value you always want will remain selected, then click the Add Filter Condition button.
In the dropdown select the same field and you can leave all values selected if that is the default functionality you would want. Once done, hit Apply.
Now, you can add the filter to your control panel or inside the sheet based on the 2nd portion of the filter:
This way, whether or not National average sales has been selected, it will always appear in the visual. I will mark this response as the solution, but please let me know if you have any remaining questions. Thank you!
