Crosstab - data formatting

[peewan]

Hi All,

I have cross tab report like in attachment,
Measure for (Promp) monthly for Country/Measure Type

In [Measure Type] has values: Charged Amount, Visits count, Days Count, Payments

I would like to set the result data formatting:
Charged Amount, Payments : with '$' in the result
Visits count, Days Count: normal number

Thank you,

[maced62]

Peewan,

In your crosstab, select one of the measures, I will use Charged Amount as an example.  When you select the measure, it will highlight and then you should see the Properties box.  Scroll down in the properties until you find the item labeled Data Format and then click the ellipsis (three dots) to open the Data Format dialog (see attached Example3.png).  In this dialog, select Currency from the dropdown and then choose the formatting options for currency. 

Do this for each measure you wish to display as currency and that should do it.

maced62

[peewan]

Peewan,

In your crosstab, select one of the measures, I will use Charged Amount as an example.  When you select the measure, it will highlight and then you should see the Properties box.  Scroll down in the properties until you find the item labeled Data Format and then click the ellipsis (three dots) to open the Data Format dialog (see attached Example3.png).  In this dialog, select Currency from the dropdown and then choose the formatting options for currency. 

Do this for each measure you wish to display as currency and that should do it.

maced62

Thank you for quick reply.
It won't work.

I noticed about data format in the properties. But it for changing format for [single data item] only.
If my Crosstab has 4 difference data items for each Measure Type ([Charged Amount], [Visits count], [Days Count], [Payments]), I can just select one of each and do this option.

But I just have 1 [Measure Type] data item, and itself has 4 value (Charged Amount, Visits count, Days Count, Payments); so i may need to do difference way.

Thank you.

[Francis aka khayman]

is this a dimensional or relational report?

you have to separate the measures to format them differently.

if dimensional you can somehow tuple measure type and measure.

if relational you can create calculations something like ... if  [measure type] = 'Charged Amount' then [Measure] else 0. add them to your rows and format separately

[peewan]

I got it fixed by using "Conditional Styles"
Thank you :)