Colour change as per the selection in dynamic selection report

[vikasshana]

Hi,

I've dynamic selection report implemented in my organization as "Dim" and "Measure" as two selection boxes and based on the selections in "Dim" and "Measure" Report gets populated. Now requirement is when users select Dimensions from "Dim" List box and measures from "Measure" List box back ground Color has to change. Example as below.

Dim

Test1

Test2

Test3

Test4

Test5

Measure

Sales1

Sales2

Sales3

Sales4

Sales5

Sales6

So for example user selects Test1 and Test2 from Dim and Sales1 and Sales2 from Measure I want the background color of Sales1 and Sales2 has to change when sales2<=Sales1 then Sales1 background color has to be green and when sales2>Sales1 then Sales1 background color has to be red, this logic needs to be applied when ever user selects only sales1 and sales2 from measure. When user selects other measures apart from sales1 and sales2 it has to be default white.

Expected Output:

Regards,

Vikas

[chrismarlow]

Hi,

Don't know if the dynamic report piece affects this but maybe try something like this;

Cheers,

Chris.

[vikasshana]

Thanks for that Chris, but it is not working for me and moreover the calculations are happening at the backend so I don't want to use sum(Sales1)>sum(Sales2) in the expression I just want only the fields.

[vikasshana]

Can someone help me on this as this is a high priority requirement.

@sunny_talwar @Anil_Babu_Samineni @tresesco 

[chrismarlow]

Hi,

I think you are going to need to share more about how your dynamic selection report works, dimensions/expressions etc ... particularly if you are precalculating things.

Cheers,

Chris.

[vikasshana]

Hi,

In my application I've created a data model by extracting fields from different data sources and using the same fields in the script to create a dynamic selection report and in the same way I'm using basic sum(sales) calculations.

[vikasshana]

Can some one help me on this please.