Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ^^
May be this
=Count( DISTINCT {$<[Calendar JnJ Year]={$(=Max([Calendar JnJ Year]))}, [CalendarJnJQuarterDesc]>} [CalendarJnJQuarterDesc])
May be this
=Count( DISTINCT {$<[Calendar JnJ Year]={$(=Max([Calendar JnJ Year]))}, [CalendarJnJQuarterDesc]>} [CalendarJnJQuarterDesc])
Thank you very much!