number formating using set analysis urgent.........

[#1]

hi

i am creating a pivot table in which i am having 5 rows and 4 columns.

in the pivot table i have to bring %sign in some rows. how can i achieve that???

my situation is like dis

[Jason_Michaelides]

Maybe something like:

IF("Your condition here",Num("Your expression",'#,##0'),Num("Your expression",'#,##0%'))

Hope this helps,

Jason

[#3]

could you plz be more specific with an example...i have used num function but its nt wrking

[Jason_Michaelides]

Can you post your app with the condition you want to check to decide to show % or not?