Is there a way to change the value of the field in a pivot table and table box?
Field 1 Value ----- Replace Value
Uknown -------------> 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
Another question how can i hide certain field values. For example if i waned to hide values for Pink but show everything else?
you just null the particular value
what about this one?
Pie chart has dimension and expression so yes can use the same in that as well
Retrieving data ...