🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Caption and container folder for dimension

Quan Hieu asked on December 13, 2016

Hi team, 

Do we have any way to define caption or title for the column that import from CSV file? For example, I have: SaleQty, TotalAmount column in CSV file and after importing I want to display it like: Sales Qty, Total Amount in Drag Dimensions section.

And also can we define the container folder for each column. For example: SaleQty, TotalAmount will belong to Measure folder; City, Country will belong to Area folder in Drag Dimensions section.

Many thanks.

2 answers

Iryna Kulchytska Iryna Kulchytska Flexmonster December 13, 2016

Hi Quan Hieu,
Thank you for posting your questions.
Unfortunately, the options you are asking about are unavailable for CSV data source, but they both are available for JSON. Here is a sample that illustrates (1) how captions can be defined and (2) how fields can be grouped in folders: http://jsfiddle.net/flexmonster/aepvpc6e/
More details about JSON data source can be found in the documentation http://www.flexmonster.com/doc/json-data-source/
Please let me know if JSON can work for you.
Kind regards,

Quan Hieu December 15, 2016

 Thanks Iryna.

Please login or Register to Submit Answer