Different cell formats for the same column?

[#1]

Hi !

I have data and I want a different format for each value depending it is an index, price, % or unit value.

Is it possible? I tried to used Text Format in the Expression Tab, it does not work!

The following table is an example of the expected output:

	Jan	Feb	Mar
Index	0.064	0.455	0.125
Price	200.00	1,506.58	20,234.58
%	1.5%	2.3%	1.4%
Units	1,234	495	38,423

Thanks a lot for all your suggestions!

Cordially,

--- maoh

[#2]

Hi,

You can achieve it by using the custom format cell.

[#3]

First click on the grid and then right click on the chart and select the custom format cell as shown in figure 1

and do the changes as per your requirements as shown in the figure 2

[sunny_talwar · Accepted solution]

Yes it is possible in a straight table or pivot table by using if statement:

If(FieldName = 'Index', Num(Expression, 'Formatting1), If(FieldName = 'Price', Num(Expression, 'Formatting2'),... and so on.

HTH

Best,

Sunny

[jonathandienst]

If you create the table with Index, Price etc as expressions and the month as a dimension, and select the Horizontal option in Presentation, the field formats in Number become row formats.

[#6]

It works!

Also, I must indicate 'Expression Default' as number format settings (Tab Number). If you indcate another number format settings, it does not work.

Then, the result looks like:

Thanks a lot for all your suggestions

[#7]

Thanks a lot for your suggestion.