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

Show data in single row without grouping row in grouping row

Answered
Anusha A asked on December 2, 2020

There are multiple rows but in that table can we show single row with out group row 

8 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster December 3, 2020

Hi Anusha,
 
Thank you for posting your question.
 
Could you please describe your issue in more detail in order for us to understand your situation better? Additional explanations, screenshots & links to corresponding samples would also be helpful. 
 
Looking forward to your response.
 
Regards,
Mykhailo

Public
Anusha A December 14, 2020

Need to show only profit loss in single row like grand total but the values are not grand total. Not to expand as shown in screenshots

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster December 16, 2020

Hi Anusha,
 
Thank you for explaining your question in more detail.
 
To achieve something similar to the described behavior, we would suggest using the `showTotals` property of a field in the Slice object.
 
What it does is allow you to hide totals for a specific hierarchy. When used for hierarchies with one member only, this property can be used to avoid duplicating the data, which we understand is happening in your situation. 
 
We’ve prepared a quick sample illustrating the approach above: https://jsfiddle.net/flexmonster/qh1g93nz/.
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Public
Anusha A December 18, 2020

Actually, we are trying to achieve not to show aggregation values like grand total. But to show only single-line row without expanding as shown in the screenshot of profit and loss.

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster December 18, 2020

Hi Anusha,
 
Thank you for your response.
 
If we understand your requirement correctly, when a field’s member only contains one child member, you want to display it as a single unexpandable row.
 
If this is the case, please note that Flexmonster does not provide such functionality. The current pivot table behavior represents how the data is structured in your data set, and changing it would provide an incorrect representation of the input data.
 
Nevertheless, similar behavior can be achieved with a little bit of further Flexmonster customization. The first suggestion (from our previous response) would be to make the hierarchy totals invisible to ensure only one row is displayed for one child member hierarchies.
 
Next, you could do some additional CSS configurations (consider the customizeCell() API call) to remove the expand arrow from the row in question and make it look like a simple unexpandable row.
 
Please let us know if you find this helpful.
 
Kind regards,
Mykhailo

Public
Anusha A December 22, 2020

Hi Mykhailo
Can we add dynamic values in the customized cell from the outer variable?
Please let me know, how can I do it?

Public
Anusha A December 22, 2020

Hi Mykhailo
remove the expand arrow from the row in question and make it look like a simple unexpandable row. Please tell us with an example. how can we do it?

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster December 24, 2020

Hi Anusha,
 
Answering your question: yes, like any other function, the customizeCell() API call can use global variables from your JavaScript code.
 
We’ve modified the previous example to illustrate the described behavior with the help of customizeCell() & some CSS configurations. Feel free to check it out: https://jsfiddle.net/flexmonster/qh1g93nz/
 
We hope this helps.
 
Regards,
Mykhailo

Please login or Register to Submit Answer