format expression in pivot table based off qualifier field

[#1]

I have a pivot table that I have created where I want to format the data in the pivot based off the values contained in a qualifier field.

For example:

where form = 'late_loads%' the result for the attribute field eg. Jan-2009 should be a %, for everything else the current format is acceptable.

Thanks

[#2 · Accepted solution]

I tried to simulate your with some data I have. The following works for me:

Expression:

=if(Right(Form,1)='%',num(Sum(Value),'0.00%'),num(Sum(Value),'#,##0'))

Format:

Expression default.

Result:

Hope this works.

Regards,

Kiran.