Pivot Table selected values

[#1]

Hello I have a pivot table.

Is it possible that my table only reacts on changes of one variable used?

[Anonymous · Accepted solution]

Hello, Ama.

Yes, it's possible. You can use an expression set analysis to disregard selections on specific fields. Let's say your data model has the fields Client, Product and Year but you don't want the selections in Client and Product to affect the pivot table. You would write your expression(s) like this:

Sum({$<Client=, Product=>} Sales)

With expressions like these, only Year would make the pivot table react.

Hope it helps,

- Bruno