1 Reply Latest reply: Jun 21, 2012 5:46 PM by brandon breitling RSS

    Calculated Dimension moved to expression

      Hi Community,


      I have a graph with two calculated dimensions and an expression. How would I change the calculated dimensions to plain dimensions of GL_Account_Number_Name_Balance_Sheet3 and Department_Number_Name3?


      Here are the calculated dimensions:




      Here is the expression:

      sum({ $< QBbalcode={'DLHOURS'},






      I've tried a lot of different things but can't get the same totals. Any ideas? The reason I want to move away from calculated dimensions is that when you click on one it selects all the fields included in the calculation.