Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I have a pivot table.
Is it possible that my table only reacts on changes of one variable used?
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
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