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?