2 Replies Latest reply: Jun 21, 2016 11:35 AM by Jose Persichini RSS

    Get value of pivot table

    Jose Persichini

      Hello, I have this model loaded (note that ADM_PLAN_CUENTA-Expandednodes1 is a hierarchy table)

      Screenshot_4.png

      With this I create a pivot table which works correctly:

      Screenshot_3.png

      Now, I want to know by code the value, for example, of "RECURSOS CORRIENTES" to do a calculation with this. It is the sum of the nodes below this. I need exact the same value I can see in the pivot table, month by month.

       

      How can I get it?

       

      Thanks!