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)


      With this I create a pivot table which works correctly:


      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?