Background Color

[bkn]

I have a Listbox with values Q1,Q2,Q3,Q4.. My requirement is : When I select Q1 and Q2 together , then my pivot table background will be changed base on numbers and when i select Q1 and Q2 and Q3, the background color change in Pivot Table.

How can i write expression to have the multiple value selected in ListBox ?

Thanks in Advance.

[maxgro]

if your listbox is on field1 and you want to check if Q1 and Q2 are selected (green) or possible (white)

=if(concat(distinct field1, '', field1)='Q1Q2', 1, 0)

[bkn]

IF(FiscalQuarter='Q4' AND FiscalQuarter='Q4',

if([Sold]/[Target]>=0.138, LightGreen(),

  if([Sold]/[Target]>=0.111, Yellow(),

  if([Sold]/[Target]=0,lightRed(),lightRed())))

Can you guide me how to change this expression on your format. Please.

[bkn]

IF(FiscalQuarter='Q1' AND FiscalQuarter='Q2',

if([Sold]/[Target]>=0.138, LightGreen(),

  if([Sold]/[Target]>=0.111, Yellow(),

  if([Sold]/[Target]=0,lightRed(),lightRed())))

Can you guide me how to change this expression on your format. Please.

[Anonymous]

Hello.

Using Massimo's idea, your expression would be like this:

if(Concat(Distinct FiscalQuarter, '', FiscalQuarter) = 'Q1Q2',

if([Sold]/[Target]>=0.138, LightGreen(),

  if([Sold]/[Target]>=0.111, Yellow(),

  if([Sold]/[Target]=0,lightRed(),lightRed())))

Hope it helps.

[its_anandrjs]

Another way of doing this with Getfieldselections

=if(Replace(GetFieldSelections(FiscalQuarter), ',','') = 'Q1 Q2',

  if([Sold]/[Target]>=0.138, LightGreen(),

  if([Sold]/[Target]>=0.111, Yellow(),

  if([Sold]/[Target]=0,lightRed(),lightRed() ) ) ) )

[bkn]

Thanks, it works ...