set expression {1}

[JonathanKelly]

I have a pivot table that I am counting status against a company, I do not want this to change when a date filter is applied. I know this can be done using {1} set expression but when I input count({1} Status), this doesn't lock the pivot table and the date still changes the data accordingly.

[vinieme12 · Accepted solution]

Do confirm if you have any calculated dimensions in the pivot table?

Because {1} will always ignore all selections

Also check if the table is assigned to an alternate state