Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a requirement to have the following chart in a document:
Timescale | Target | Last Week | This Week | Variance |
---|---|---|---|---|
Sales | 15 | 20 | 10 | -10 |
Target, Last Week, This Week, Variance are values of the Dimension Timescale, Sales is an expression to return the values.
This tricky bit is the formatting that is required, I need cells highlighted comparing the results to the target, I'm unsure on how to write the code for a dimension to compare say Last Week to This Week
Any ideas/suggestions?
Regards
Chris
Hi.
You can use set analysis to get the result for corresponding dimension values.
sum(total {<Timescale={"1:Target"}>}Sales)
The total is used here to have this value for each Timescale value.
Then you could write an expression for background color for your originall expression (Plus sign to the left of the expression name on expression tab).
Hi.
You can use set analysis to get the result for corresponding dimension values.
sum(total {<Timescale={"1:Target"}>}Sales)
The total is used here to have this value for each Timescale value.
Then you could write an expression for background color for your originall expression (Plus sign to the left of the expression name on expression tab).
Thanks... still trying to get my head round set analysis, but your solution is working perfectly. My first attempts were missing the Total element