There are multiple rows but in that table can we show single row with out group row
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.
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
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.
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.
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.
Can we add dynamic values in the customized cell from the outer variable?
Please let me know, how can I do it?
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?
Answering your question: yes, like any other function, the
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.