Hi,
I have a data table as follows:
Month | KPI_ID | Num | Denom |
---|
01/04/2018 | KPI_001 | 7 | 30 |
01/05/2018 | KPI_001 | 18 | 45 |
01/04/2018 | KPI_002 | 6 | 72 |
01/06/2018 | KPI_002 | 9 | 54 |
etc... | | | |
I need to put this in a STRAIGHT table as I need to use mini charts to show a trend.
I need the KPI_ID down the side and also to put the Months across the top of the table so I need to use expressions to do this.
Some KPIs are calculated as SUM(Num)/SUM(Denom), some are just SUM(Num)...some are more complicated so I wanted to keep all of this logic within a variable (vFormula)
I was then going to put my expression as =Sum({<Month={"$(vFinYear_Apr)"}>}$(vFormula)) but I can't get it to work...any ideas?
If my variable is just Num (with no preceding 😃 then it does give the correct result for that, but anything more complex and it doesn't work.
swuehl