OBIEE - Adding a dynamic currency symbol to table values

Question

Hi,

I have a currency dropdown on my dashboard and a table showing Gross Revenue metric for a specific currency.  I have a requirement to add the currency symbol to each G.R. value in the table.  To do this I've set a presentation variable(p_curr_symbol) on the currency dropdown and appended the presentation variable to the G.R. column like so  '@{p_curr_symbol}{$}'||CAST("Fact"."Gross Revenue" AS CHAR). This works well until I apply column sorting. Since the column is now a char the sorting will order the values reading from left to right, so asc sorting will order value 123 before 23.

Anyone had a similar requirement and has been able to resolve the sorting?

Thanks.

OracleUser_MUC6U · Answer

Thanks Pedro.

We need to allow the user to sort asc/desc on any column in the table including the G.R. column with currency symbol.

Pedro F · Answer

Hi,

I don't you just add the original Gross Revenue metric to the analysis as well, add a sort to that column and in the column properties hide this column (checkbox). That way, you can add this column to your table and the sort will be applied.