asked on August 10, 2016
Hi,
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,
Sunilkumar.V
⋅ 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: https://jsfiddle.net/irynakulchytska/zLjesrsr/
Please let me know if the above approach works for you.
Kind regards,
Iryna
⋅ August 18, 2016
Hi Iryna,
yes, it works for me.
Thanks & Regards,
Sunilkumar.V
⋅ December 7, 2016
Hello Sunilkumar.V and all Flexmonster users,
After the release of version 2.3, we would like to provide you with the updated sample: https://jsfiddle.net/flexmonster/2fajgm7z/.
Regards,
Tanya
