Display Max Date Values only and background color of the dimensions in the same Table

[Anonymous]

Hi All,

I have a requirement to display only the Max Date values in the table. I could achieve that using the formula , Set analysis 

Sum({$<COBDate_Input = {"$(=Max(COBDate_Input))"}>} APAC_SPEND_CHF).

But the issue is , when i give a condition on certain other dimension columns for the background color (For Example if Column A = 'ABC',color red), the other date values also appear. Kindly suggest.

How do i handle the dimension background color.

[sunny_talwar]

Are you using column reference or an expression? If it is an expression are you adding the same set analysis that you have in your main expression to your color expression?

[Anonymous]

Hi,

No i haven't used the set analysis in background expression editor.

Soo are you telling that i need to use my set analysis expression into the background expression?

This is my set analysis expression for a Measure : Sum({$<COBDate_Input = {"$(=Max(COBDate_Input))"}>} APAC_SPEND_CHF)

But i need to bkg colour to another column which is a dimension. which has values H,VH,M. Like for H, Bck needs to be red etc

Kindly suggest how do i use the set analysis to a dimension.

[sunny_talwar]

What exactly is your background expression right now?