2 Replies Latest reply: Feb 8, 2017 5:59 AM by Dafnis X RSS

    Dimensionality for custom subtotal in pivot table

    Dafnis X

      Hi All,

       

      I am trying to modify a subtotal using Dimensioanlity:

       

      In case a dimension has the value 3, to sum items from dimension 2 and 3, which are flagged in the script.

       

      =if(Dimensionality() =2 and Balance_TotalCode =3, sum({<Balance_Flag_TOTALCOMMANDEQU={'1'}>}Balance_Amount),sum(Balance_Amount))


      In the data:It should sum the items in orange (Balance_TotalCode =2) and green (Balance_TotalCode =3)

      But It only sums the items in green.

      The row in yellow represents the desired location with the wrong result.

      DimensionalityIssue.png


      Will appreciate assistance!


      Thanks!