How to display text inside the column cell?

Hello Subash,
 
Thank you for the question.
It is not possible to show text in the cells, because those values are aggregated (and there is no way to aggregate text values).
But, please take a look at the Flat Table demo, maybe it will suit your needs.
 
Best regards,
Ian

Hello, Rodrigo,
 
Thank you for reaching out to us.
 
We would like to kindly inform you that only count and distinct count are available for the string data type.
 
However, as a workaround we suggest using the customizeCell API call in order to achieve the desired functionality. For example, an approach for your case can be similar to the following:

1. Specify the hierarchy named "Description" and place any value in it. The data type can be both string or number. The hierarchy is going to be used as a wrapper for an actual description.

   {
   	"Agent": "Agent B",
   	"State": "VIC",
   	...
   	"Description": ''
   },
   {
   	"Agent": "Agent A",
   	"State": "VIC",
   	...
   	"Description": ''
   }
   

2. Also, add another property named "Description Text" and place the desired description of the record in it:

   {
   	"Agent": "Agent B",
   	"State": "VIC",
   	...
   	"Description": '',
   	"Description Text": "The desired text"
   },
   

3. Specify the data type of the hierarchy "Description Text" as property. This will hide the field from the Field List. Also, the hierarchy property has to be set to the name of the hierarchy the description is about. Data types should be specified using the mapping property of the dataSource object. The structure has to be similar to the following:

   mapping: {
       Agent: {
           type: "string"
       },
       State: {
           type: "string"
       },
       ...
       "Description Text": {
           type: "property",
           hierarchy: "Airline"
       }
   }
   

4. Adjust the customizeCell method so it replaces the cell's inner text with an appropriate description. E.g.:

   flexmonster.customizeCell(function customizeCellFunction(cell, data) {
       if (data.measure && data.type != 'header' && data.measure.uniqueName == "Description") {
           for (let elem of data.rows) {
               if (elem.hierarchyName == "Airline")
                   cell.text = elem.properties["Description Text"];
           }
       }
    });
   

Please check out an example we have prepared for you.
More information about customizeCell API provided by Flexmonster can be found following the link: customizeCell method.
Detailed description of the mapping object: Mapping Object.
Manual on using JSON data types: Data Types in JSON.
 
We hope it works for you.
 
Do not hesitate to contact us in case of any additional questions on this point.
 
Best regards,
Illia

Hello, Rodrigo,
 
Thank you for reaching out to us.
 
As for aggregation of the columns "2020 Sales TTV" and "2019 Sales TTV", the reason for such behavior was incorrect type definition in the mapping object. We have modified an example so it displays the correct information with all required aggregations available.
 
Talking about the mapping object, you are right about the fact that all hierarchies and measures from the data set have to be at least mentioned in it. In case some hierarchies are missed in the mapping object, they will be ignored by the component and do not appear in the Field List. However, we recommend specifying the type of hierarchy in order to avoid unexpected results due to automatic type recognition.
 
We hope it helps.
 
Do not hesitate to contact us in case additional questions on this point occur.
 
Best regards,
Illia