Crosstab formatting options

[Former Member]

Hi all,

is it possible in SAP Design Studio to change format of values in crosstab component?

I have measure in IDT, set to display as %

In Query preview, it looks OK, values are shown with % symbol.

When I choose universe as data source in Design Studio and set Initial View of data source, there are values shown without % symbol.

And then the same in the crosstab, when I execute it, values are shown without % symbol.

I can't see any setting to format the values in crosstab.

Any idea about this issue?

Thank you.

Best regards,

Martin Laurinec

[Former Member]

Do you have the symbol "%" located at the top of your column ?

When all the data have the same unit, you can be able to display unit in all cell or only at the top of the column.

Look crosstab option to find this, and choose the 2nd option

Regards,

Jonas.

[Former Member]

Hi Jonas,

thanks for your reply.

Unfortunately I don't have % symbol in header or in data cells. I tried both of the options, but I wasn't successful.

I check the display of universe values in Web Intelligence, there are correct formats with % symbol and also with predefined color for example.

It seems, Design Studio can't get the format definitions from universe and therefore I can't set this format in crosstab component. In chart, there is format option in Additional Properties - Data Label

Best regards,

Martin Laurinec