Filter rows in straight table / chart by aggregated value

[Anonymous]

Hi,

I am trying to filter out rows with a particular row-id, row-id itself is produced via aggr formula:

AGGR(nodistinct min({<[Comment number]  = {">1"}> } [comment-id] ),[Ticket number])

A bit about columns

[comment-id] - unique identifier of the row

,[Ticket number]) - object I am working with, it can be considered invoice number with [comment number] being items

[Comment number]  - sequence number of a comment within [Ticket number], each ticket has its comments numbered 1 to n, I have to exclude the first and find the lowest second value. I might not be 2 as rows might be filtered out by other filters.

[Anonymous]

PS. Hiding rows will not do it as average / count / fractile will be off.

[Anonymous · Accepted solution]

I ended up using calculated Dimension + similar filters when calculating fractile / sums:

if

  (

  AGGR(nodistinct min({<[Comment number]  = {">1"}> } [comment-id] ),[Ticket number])=[comment-id]