0 Replies Latest reply: Jul 11, 2012 2:32 PM by brandon breitling RSS

    I have 2 dimensions with same fields, want to use other one in chart.

    brandon breitling

      Hi community,

       

      I have two dimesions with the same field values but in different tables.  I can't link them in the script for other reasons.  Is there away I can use the other one as the dimension for a graph? 

       

      The dimension I have that works is el1_sname but I'd like to use [Division Abbreviation].  Here is my expression:

       

      sum({ $< balcode3={'ACTUAL'},

      LinkYear= {$(=$(vCurrentFiscalYear))},

      LinkMonth=CurrentDocumentMonth3,

      el2={'17020','17030','78010','78020','78030','78040','78050','78060','78070','78220'},

      el3={">=1999"},

      [code3]={'RBIACCT'}

                   >}

                   Tot3)

      I tried adding something like el1_sname={"division abbreviation"}, to the expression but that didn't work.  Is there something similar that I might do?