I want to add multiple properties in header section, So I have tried with classic grid option, But the problem is if I am using multiple rows, then the second and third row properties will be grouped by under the first row property. I want to add multiple rows classic grid without grouped by. Which means If I have 6 columns, then the first three columns should be displayed as separate row and the remaining columns are should be displayed as columns. How can I Achieve this?
Thank you for writing to us.
We would like to confirm if we understand your case correctly.
Please see the following JSFiddle example: https://jsfiddle.net/flexmonster/yf581o5x/
In this example, the
Reseller field has additional properties represented as multiple rows. It is also possible to filter the multiple rows (hide/show) through the
Properties right-click context menu option.
Could you please confirm if this is what you are looking for?
If not, could you please provide additional details, screenshots or illustrations of the desired output?
This will greatly help us to understand the situation better.
Looking forward to your reply.
Really thanks for your quick reply. but that’s not my expectation.
My expectation is , Please take a look at the attached image.
In the attached image have some columns are there, but these below columns are having same values under ANY WIRE-V0013456 and HIGUE POWER CONTROL PRODUCTS-VMH00256 headers.
Columns: Sum of AceRate, Sum of SuggestedRate, Sum of SalesRate and Sum of Quantity
I don’t want to show this duplicated columns repeatedly, because of same values. So I am expecting to show these every columns as a separate row like MATERIALCODE. I hope you clearly understand my requirement. Kindly resolve this.
Any update for this?
Thank you for providing further details and giving us some time.
It seems that the described layout is not supported at the moment.
compact layout, data is aggregated and fields are grouped as a result.
On the other hand,
flat layout shows raw and non-aggregated data.
1. There is a possibility to use
classic layout. Then expanding all rows and repeating the labels in the empty cells via the customizeCell() hook. This option seems to be the closest to the desired output.
Please see the following JSFiddle example for illustration: https://jsfiddle.net/flexmonster/rwdgv2f8/
2. Another option is to create separate views. It is possible to open another pivot showing a different slice of data.
Here are a few examples of how this can be done:
2.1) Opening another pivot from Flexmonster’s context menu: https://jsfiddle.net/flexmonster/dbaw72fw/
2.2) Opening another pivot in a pop-up window from Flexmonster’s context menu: https://jsfiddle.net/flexmonster/1rm53nt9/
In addition to customizing the context menu for opening another pivot, the cellclick event could be used as well.
We hope this helps.
Please let us know if any further questions arise.
Really thanks for your suggestions @Vera.