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

How to add multiple rows without grouping in classic grid?

Ramesh asked on January 22, 2020

Hi Team, 
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? 

5 answers

Vera Didenko Vera Didenko Flexmonster January 23, 2020

Hello, Ramesh,
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.
Best regards,

Ramesh January 23, 2020

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. 


Ramesh January 24, 2020

Any update for this?

Vera Didenko Vera Didenko Flexmonster January 24, 2020

Hello, Ramesh,
Thank you for providing further details and giving us some time.

It seems that the described layout is not supported at the moment.
In classic and 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.

Kind regards,

Ramesh January 27, 2020

Really thanks for your suggestions @Vera. 

Please login or Register to Submit Answer