RE:Selected values

[Chanty4u]

Hi all,

I have small pivot table table and  one listbox  so   i want to show the data as per listbox values selection

Listboxvalues

Above50%

Below50%

All

so if  i select  any value that should be displayed as per selection.

Best

chanty

[kristof_j]

Hi Chanty 4u

I changed your script a bit and added a dual for your percentages.

Then I changed the dimensions using the dual with a pick statement

Does this help?

[Anil_Babu_Samineni]

Chanty, might be ad hoc Reports

[tresB]

May be like in attached qvw.

[Chanty4u]

Thanx.

But in your Qvw its not working for below 50%

[tresB]

Small correction. Try:

if(perce='all' or count(perce)>1,actual/trget,

If( Left(perce,5)='above', If(actual/trget>left(right(perce,3),2)/100, actual/trget,0),

  if( Left(perce,5)='below', If(actual/trget<left(right(perce,3),2)/100,actual/trget,0))))

[Chanty4u]

yeah.tresesco‌ its still not working .As expected. And one more thing is i don't want extra column for this ?

how it is possible ?

it showing all values if i select in listbox .

[tresB · Accepted solution]

Like this?