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:
=if(match(QB22,el2),GL_Account_Number_Name_Balance_Sheet3)
=if(match(QB33,el3),Department_Number_Name3)
Here is the expression:
sum({ $< QBbalcode={'DLHOURS'},
LinkYear={$(=Only("CurrentDocumentYear"))},
LinkMonth=CurrentDocumentMonth3,
={'RBIACCT'}>}full_value)
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.
