Just beginning to explore the possibilities of alternate states and have a question I haven't managed to find the answer to.
Basically, I have a pivot table that compares factory statuses by factory name and I have set up 2 alternate states (MonthYearOne & MonthYearTwo) in order to allow the user to choose 2 months to compare.
My problem is that I want all other selections made in the document to apply to the pivot table. I have amended the expression as per the below to allow enable to the table to take into account any selections made on the [Factory Name] field, but want to know if there is any way of allowing selections on all other fields to be taken into account in the alternate state, without having to explicitly include each field name in the expression? I ave numerous other fields that users may want to make selections on in this pivot table.