Renaming field values in a pivot table

[#1]

Hi -

Is there a way to change the value of the field in a pivot table and table box?

For example:

Field 1 Value ----- Replace Value     

Hot

Cold

Uknown -------------> Green

[sivarajs · Accepted solution]

Something like

if(wildmatch(Field,'*Unknown*'),'Green')

[#3]

This formula works perfectly in a pivot table!

Now i need to apply the same formula as part of my pie chart. Is that possible?

The formula that i am using right now to calculate values as follows:

Color as my dimension and Fabs(Sum([GL Amount]))/100

Please help!

Thanks

[#4]

Another question how can i hide certain field values. For example if i waned to hide values for Pink but show everything else?

Thanks

[sivarajs]

you just null the particular value

if(wildmatch(Field,'*Unknown*'),null(),Field)

[#6]

what about this one?

This formula works perfectly in a pivot table!

Now i need to apply the same formula as part of my pie chart. Is that possible?

The formula that i am using right now to calculate values as follows:

Color as my dimension and Fabs(Sum([GL Amount]))/100

Please help!

[sivarajs]

Pie chart has dimension and expression so yes can use the same in that as well