1 Reply Latest reply: Jan 19, 2018 11:28 AM by Sunny Talwar RSS

    Set analysis - Inner aggregation not considering dimension?

    Maxime Dumas

      Hi,

       

      I am try to build a table with the following metric by User.

       

      COUNT({<[Security ID] = {"=Count({<$(=vSelectedDate)>} DISTINCT [Account ID]) <= 3"}>} DISTINCT [Security ID])

       

      In a KPI, it gives the correct answer. But if I put it in a table, it seems like the securities are grouped by user, but not the accounts.

       

      In other words, "Count({<$(=vSelectedDate)>} DISTINCT [Account ID]) <= 3" does not consider the user on the table row, but all the accounts for all users.


      Is there a way to avoid this?


      Thanks!