text format

[#1]

hi i have a column in a pivot table which have values with $ sign notation and i want 1 column to be shown without $ sign. how can i do that?

[vijay_iitkgp]

If it is dimension then you can use purgechar(field,'$') as calculated dimension

[jagan]

Hi,

Use calculated dimension

Dimension 1 - without $ symbol

= Replace(FieldName, '$', '')

Dimension - with $symbol

=FieldName

[#4]

no its not a dimension. its an output of an expression that i have used in the pivot table and its not a string..its a no.

its coming like this $89750.90 and i want to remove it only from the ist row.

[#5]

hi Jagan

its not a dimension and the solution you have provided is not even wrking for a dimension.

[vijay_iitkgp]

Please go to Chart Properties----->Number------>

you can see the formatting option. here you can remove $.

Regards

Vijay

[#7]

hi Vijay

i dont want to remove it from the whole column i just want to do it for the ist row of column.

i have rows like a,b,c,d and their corresponding columns are p1,p2,p3.

i want to do it for only a.

[Anonymous]

In this case you need to evaluate first row by using RowNo() function and then use the number formatting function like Num# to format your expression for true and flase condition of if function.

If(RowNo() = 1, Num#(Expression,formatforfirstrow),Num$(Expresiion,Formatforotherrows)

Hope it helps!