1 Reply Latest reply: Dec 2, 2014 9:11 PM by Bruno Souza RSS

    Pivot Table selected values

      Hello I have a pivot table.

       

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

        • Re: Pivot Table selected values
          Bruno Souza

          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