Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Something like
if(wildmatch(Field,'*Unknown*'),'Green')
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
Another question how can i hide certain field values. For example if i waned to hide values for Pink but show everything else?
Thanks
you just null the particular value
if(wildmatch(Field,'*Unknown*'),null(),Field)
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!
Pie chart has dimension and expression so yes can use the same in that as well