We use Flexmonster to show statistics by raw material, and statistics are done from number of individual value (sample_code).
Statistics are shown from calculated values but we’d liked to display these values only for raw materials and not for individual value (sample_code), I am not sure to be clear ?
Attached are 2 screenshots of what we have and another one (nir-display-wanted) to explain what we’d liked to get
Thanks, best regards
Thank you for writing to us.
As we understand, you want to achieve the following scenario:
1) if the member of raw_material is expanded, only one value is shown
2) if the member of raw_material is collapsed, all statistic numbers are shown
If this is the scenario you need, we need to inform you that it is not supported in Flexmonster. However, there can be some workarounds with opening new pivot table in the pop-up window.
Please let us know your thoughts on the subject.
OK thanks Tanya, it was my request, and we did find out about views in pop-up windows but these views can’t be saved, can they ?
Thank you for the additional question.
If you show the second pivot table in the pop-up window, the API calls will be available for this instance as well, including such calls as
save() . Also, you can show the pivot table in the pop-up window with the Toolbar to display Save button. Thus, you will be able to write the scenarios when the state in the pop-up window can be saved.
Here is a JSFiddle example https://jsfiddle.net/flexmonster/1rm53nt9/ that illustrates how the context menu can be extended with the item “Open in New Pivot” (available through a mouse right click on the numeric cell). The idea of the workaround for you was that you can extend the context menu for the cells that can be expanded with the new item. When a user clicks on this item, your code can get the current report through
getReport(), expand the node there, leave only one measure there and display this slightly changed report in the pivot table in the pop-up window.
Please let us know if the idea of the workaround is clear and if it can work for you.