Format of the values changes when we switch to Flat Form.

when we toggle between the different views, the format of the data does not persist.
Example, customer code 1002 in classic form, gets converted into 1,002 or 1 002 in flat form.
When we see the format of the column in the formatted window, thousand separator is in space.
How do we retain the format of the data when we switch between layouts?
Thanks & Regards,

2 answers

Iryna Kulchytska Staff August 11, 2016

Hi Sunilkumar,
If customer code is not a value for aggregation, but a numeric field that is usually used on rows or columns in the pivot table, then you can define { “type”: “string” } data type for it. Thus, it will be considered as a string value in Flat Form and the number formatting will not be applied to it.
Here is a sample:
Please let me know if the above approach works for you.
Kind regards,

kumar August 18, 2016

Hi Iryna,
yes, it works for me.
Thanks & Regards,

Please login or Register to Submit Answer