I'm having issue with $ variable in Combo Bar Chart aggregation.
1st, I need to use Combo Chart.
X axis is FISCAL_YEAR_APR,
Left Y is SUM(APR_AMOUNT),
Right Y is SUM(COST_FINAL).
I have defined a variable (vAPR) as APR.
My specific problem is with the Stacked Bars I need for SUM(APR_AMOUNT).
The expression I'm using is: =sum({< [APR]={'=$(vAPR)'} >} [APR_AMOUNT] ).
Other versions of the expression have been tested but I've not figured it out. I've attached a .qvd with my progress. In this .qvd there are two years properly displaying because I specifically denoted the APR's in the expression using (example) =sum({< [APR]={'19-HLP-04'} >} [APR_AMOUNT] ). How do I get my variable to generate the multiple stacks in the bar chart? There's got to be a way!
APR is our term for "project number". What I need to see is the SUM of APR_AMOUNT for each APR in a stacked bar for the X axis "FISCAL_YEAR_APR". So, in 2010, I'd need to see 8 different colored stacked sections totaling $937,837. See the columns for 2018 and 2019 for examples.
I stopped entering expressions for each [APR] after completing 2018 & 2019. It was killing to do that because I know there's got to be a better way of yielding the desired result.
