Input Box Doubt

[rohitians]

Hello,

I have a pie chart with cylclical drill (Product,City,Value) I am giving an input box to user to select suppose top 10 or 20.

But if the user does not selects any value in the input box the pie chart should consider all available values rather then 10 r 20...

Please help how can i do that ...

In dimension limit i took that variable Example vTop so if he select 10 so 10 is limit...

what do i do if user selects nthng i have to show all the values how do i do that...

Thanks and Regards

Rohit

[#2]

Can you please upload an sample document

[sushil353]

try to use if condition

if(variable=10 or variable=20,variable,30000)

HTH

Sushil

[rohitians]

Hey,

See in the dimension limit i am writing the variable name means if user chooses 10 den i show top 10 but he does not chooses anythng then i should show all the available values....

Thanks and Regards,

Rohit

[rohitians]

Hello,

If User Chooses 0 den then all 665 products should be displayed..

Is the expression right????

if(vTop=0,vTop,665)

[sushil353]

try this:

if(variable=10 or variable=20,variable,if(vTop=0,665,665))

HTH

Sushil