Count with trick

[Anonymous]

Hello,

Please help me to add condition, which calculate count base on product type and the latest date. Or may be different algorithm.

Some client switched from one type to other. I should calculate the latest product.

Please see my attached file.

Thanks,

[swuehl · Accepted solution]

Create a chart with dimension

=aggr(FirstSortedValue(Product,-[Close Date]), [Account Number])

and as expression

= count(distinct [Account Number])

If you want to group Ent / Pro, I would suggest doing the grouping in the script, creating a new field.

[Anonymous]

Thanks, Stefan.

It works for this case.

Thanks again.