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.

      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))},







      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?