Format table column in dashboard as currency?

[CBDSV]

Hello,

Wondering how I can display an Amount value in a dashboard in currency format, it is in currency format in the data source ($.1,848.15) but shows as 1,848.15 in the dashboard.

Also wondering if there is an easy way to create a custom order for column sorting (Ex. I want sort ascending to sort column "Month" as Jan, Feb, Mar, etc...)

[CBDSV]

bump?

[MFGF]

Hello,

Wondering how I can display an Amount value in a dashboard in currency format, it is in currency format in the data source ($.1,848.15) but shows as 1,848.15 in the dashboard.

Also wondering if there is an easy way to create a custom order for column sorting (Ex. I want sort ascending to sort column "Month" as Jan, Feb, Mar, etc...)

Hi,

This type of formatting is possible in Cognos Analytics 11.1.1 dashboards. I'm guessing you are on an older 11.0.x version?

Cheers!

MF.