Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.