Its a table with some companies with information what group they belonged in that month. This info it's necessary cause I need show to the user the historic of our KPI officially reported in that specific date. So because that I create the synthetic table with DataUnica cause this only will show me companies that belonged to the specific month of the filter of the user. But the question it's when user don't put any filter, when this happens I need to show only the companies that belong to the newest date in this table.
For do this, I need a aggregation cause Set Analysis only work with aggregation fields (sum, count, max min etc..) And I need all this in a Filter: example:
The user filter the:
Yerar = 2017
Month = Jul and Aug
Avaliação = SI
so my report need bring to the user the companies belong to max(DataUnica) and belong to SI group.
How I do this?!
I've tryed the follow (into Avaliação Filter Pane): Aggr(NODISTINCT MAX(DataUnica), Avaliação) and the result was:
And I need the group RNSA or SI in this filter. How I can make this work? I need the RNSA and SI group always but If exist more than a single month I need load only the newest companies in the PESQ Tables, and If a range or YTD date, load the newest group.