Get Free Trial

set uniquename pivot

Answered
Daniele Balducci asked on November 4, 2021

Greetings,
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

Attachments:
screenshot.PNG

3 answers

Public
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: https://jsfiddle.net/flexmonster/8f3g9sou/.
 
Please let us know if it works for you.
 
Kind regards,
Illia

Public
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:
https://goprofit.2digit.sm/gest/test.php?Azione=datashare
It’s possibile to make this?
Thanks

Public
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: https://jsfiddle.net/flexmonster/f71ahgub/.
 
Please let us know if it helps.
 
Kind regards,
Illia

Please login or Register to Submit Answer