2 Replies Latest reply: Sep 6, 2017 11:33 AM by Ana Carina Rodrigues RSS

    How to count a field independently of the selection made?

    Ana Carina Rodrigues

      Hi,

       

      I have a column with years and another with quarters.

       

      I'm trying to get how much distinct values exists on the "CalendarJnJQuarterDesc" column for the selected year, but I don't want it to change the value according to the selected quarter.

       

      I'm using the following code:

       

      =count( DISTINCT {$<[Calendar JnJ Year]={$(=Max([Calendar JnJ Year]))}>}  [CalendarJnJQuarterDesc])

       

      each year has 4 quarters, so it should return always 4. But if I select Q1, it changes to 1.

       

      Can somebody help me?

       

      Thank you ^^