how to restric dimension values in Pivot table?

[#1]

Hi i have country column,

india

china

usa

now i want to show only india data in pivot table with out list box selection

please help on

[v_iyyappan]

Hi,

Use  the set analysis u can get the result.

For example:

Sum({<Country = {'India'}>} FieldName)

Count({<Country = {'India'}>} FieldName)

If it is not correct please provide sample app to give the solution.

Regards,

Iyyappan.