Comparing Results of Dimension

[#1]

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

[whiteline · Accepted solution]

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).

[#3]

Thanks... still trying to get my head round set analysis, but your solution is working perfectly.  My first attempts were missing the Total element