Count Distinct values for (2) fields for all records upto selected date

[#1]

Hi,

I am using the following expression, but it only counts for the current date selected and not for all records UPTO that date. Please help

Sum

(Aggr( Count(Distinct {$<Date ={"<=$(=Max(Date))"}>}abc),def,abc

))

[#2]

Have you tried with 1 instead of $?

Sum

(Aggr( Count(Distinct {1<Date ={"<=$(=Max(Date))"}>}abc),def,abc

))

[#3]

Sorry, no change... working the same way.

[#4]

Can you share a sample app?

[#5]

Attaching a sample app:

Now,

In the attached spreadsheet the total count for

Scenario = 1 and Timing = 1 should be 1 for Jan but it should be 2 for Feb since it should count all the Distinct values from earliest start date to current date .

Similar for Scenario 1 and Timing 2.

[#6]

Hello Everyone,

Any ideas for my problem...... I attached a sample app.