How to group data Fields?

Hello, 
 
Thank you for writing to us.
 
Could you please explain more about what you would like to achieve?
In addition, screenshots and illustrations will greatly help us to understand your case better.
 
Waiting for your reply.
 
Best Regards,
Vera

Hello, 
 
Thank you for providing more details about your use case.
 
We are glad to confirm that this is possible via the mapping property.
Please keep in mind that it is important to define all the CSV columns in the mapping property and they should be in the same order as defined in the CSV data. 
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/j8vzLnm5/

For more information about JSON data types, please see the following guide: https://www.flexmonster.com/doc/managing-data-presentation-json
 
Please let us know if this helps.
 
Best Regards,
Vera

Hello, 
 
Thank you for the update.
 
1) About only one hierarchy member being selectable at a time:
Yes, you are right. This is because in the hierarchy it is possible to select the field (hierarchy level) from which to start displaying the hierarchy.
For a better understanding, please see the example when the hierarchy has more than two levels: https://jsfiddle.net/flexmonster/mwe6uh9s/
 
If you would like to display fields independently, it is possible to use dimensionUniqueName instead: https://jsfiddle.net/flexmonster/qyokpj45/
However, it is important to keep in mind that with dimensionUniqueName it is possible to define only one level.

Also, we suggest checking out the classic layout: https://jsfiddle.net/flexmonster/Lhgra3t8/
 
2) Regarding label names:

2.1) Could you please confirm that:
2.1.1) All of the columns that are in your CSV data are present in the mapping property
2.1.2) All the fields in the mapping property are placed in the same order as defined in your CSV data. 
In addition, it will greatly help us if you could provide a JSFiddle example (with JSON data) illustrating what you would like to achieve.
This will greatly help us to understand your case better.
 
2.2) It seems the desired output can also be achieved by defining a single field "Gender" containing the values "male" and "female":  https://jsfiddle.net/flexmonster/hq8bL0ey/
 

Waiting for your reply.
 
 
Best Regards,
Vera

Hello, 
 
Thank you for your response and for providing a screenshot for illustration.
 
 
We are glad to hear that you managed the solve the issue regarding label names.
 
 
As for the desired output:
1) You can filter the shown results via the setFilter() Flexmonster API call ( https://www.flexmonster.com/api/setfilter/ ), for example:

function showResultsForMale() {
   pivot.setFilter("Gender", {
       "members": [
           "Gender.[male]"
       ]
   });
}

function showResultsForFemale() {
   pivot.setFilter("Gender", {
       "members": [
           "Gender.[female]"
       ]
   });
}

function showResultsForAllGenders() {
   pivot.setFilter("Gender", {});
}

2) Also, according to your screenshot, it seems the classic layout may be of interest.
To switch to the classic layout, specify the grid type in the options object:

options: {
  grid: {
    type: "classic"
  }
}

 
3) In addition, you can use the dimensionUniqueName property to logically group your fields in the Field List.
 

Please see the following example where the above points are taken into account: https://jsfiddle.net/flexmonster/nkt0oepr/
 
 
You are welcome to contact us in case of questions.
 
 
Waiting for your feedback.
 
Best Regards,
Vera

Hello Matteo,
 
Thank you for the question.
Currently, that specific layout is not supported. It is possible to have only the members of one hierarchy on the same level.
 
Please let us know if you have any other questions.
 
Regards,
Ian

Hello, 
 
Thank you for your question.
 
Please kindly note that at the moment providing such a layout is not on our roadmap.
 
Currently, the only possible workaround is to combine the needed fields under one dimension (re-organize the data).
 
You are welcome to write to us in case of further questions.
 
Best Regards,
Vera