asked on December 2, 2020
There are multiple rows but in that table can we show single row with out group row
⋅ 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
⋅ 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
⋅ 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
⋅ 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.
⋅ 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
⋅ 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?
⋅ 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?
⋅ 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
