Get Free Trial

set uniquename pivot

Daniele Balducci asked on November 4, 2021

we have assembled the test in javascript and before purchasing the software we would like to understand if it is possible to constrain in the rows in which there are not, as in the example, the information of columns G4 and G5 (blank) so that the system does not propose the arrow to go down a level but stop at the level where the data is present.
our problem is that in the same pivot some rows have all the levels while others have only a few.
our goal is not to make the arrow appear, and therefore the relative (blank) where no further levels of detail are foreseen


3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 5, 2021

Hello, Daniele,
Thank you for reaching out to us.
We suggest organizing all the G fields into a hierarchy. In this case, blank leaf members will not be shown on the grid. Please note that “blank” members which contain children still will be shown and drillable.
Here is the JSFiddle we prepared for your reference:
Please let us know if it works for you.
Kind regards,

Daniele Balducci November 9, 2021

Ok Illia, 
the visualization is perfect but now I can’t see the columns with the possible months.
You can view my json data here:
It’s possibile to make this?

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 9, 2021

Hello, Daniele,
You can specify the desired fields in the SliceObject of the report. For example, add the “Mese” field to columns to achieve the desired result:
Please let us know if it helps.
Kind regards,

Please login or Register to Submit Answer