How to exclude one field from summarize columns but still include it in the query
Hi, I had to introduce the field [PlannedMigrationDay] in my query for the paginated report for the sole purpose of filtering the paginated report. This is the query: /* START QUERY BUILDER */ EVALUATE SUMMARIZECOLUMNS( UserResponse[Batch], UserResponse[Response], UserResponse[PlannedMigrationDay], KEEPFILTERS( TREATAS( {"2"}, UserResponse[TenantID] )), KEEPFILTERS( TREATAS( {"4"}, UserResponse[QuestionID] )), "Responses", [Responses], "Responses %", [Responses %], "T-14", [T-14] ) /* END QUERY BUILDER */ Now I have one problem: when I have two different migration dates, my results are summarized by the date of migration whereas before they were aggregated by distinct values. I don't want my results to be aggregated by [PlannedMigrationDay]. How can I modify the query to avoid that, but still have that field in the dataset of my paginated report? Thanks in advance for the help! ~Alienvolm
