Using IN-GROUPS-OF in a hold file leads to an additional tile

[Denis Ribaud]

Hi there,

we create a hold file with the IN-GROUPS-OF and then use the hold file to create a report with accross. As we are using IN-GROUPS-OF 10 tiles we have 10 tiles in the resulting hold file:

TABLE FILE TABLENAME

SUM MEASURE

BY MEASUE IN-GROUPS-OF 10 TILES

BY TIME

ON TABLE HOLD

END

But when aggregating this hold file with the following code:

TABLE FILE HOLD

SUM MAX.MEASURE

ACROSS TILE

BY TIME

ON TABLE PCHOLD FORMAT XLSX

END

we get an additional tile 11 for some rows. How do we prevent the additional tile 11 to be created

Any hint appreciated.