How to calculate distinct values ?
I have a list which has Product as parent and SKU as list. I am trying to calculate the number of SKUs with demand > 0 for all periods. Right now, using this formula - If demand > 1 then 1 else 0. The issue with this formula is that the summary adds individual SKUs with demand at yearly level. See below screenshot -
Product 1 has only one sku which has demand in all the years.
Ideally, all periods should give only 1 as the answer as there is only one unique sku under product 1 having demand. Any leads will be appreciated.
Thanks in advance.