TOTAL COUNT. I broke my head... HELP

[warfollowmy_ver]

Hello.

I found the count of the of active SKU in stock (the remainder of the last date, if the sale was for the all select period).

Now I'm trying to make a TOTAL of this indicator and all breaks down when there is a choice of shops, I do not understand what is wrong, need help !!!

[PrashantSangle · Accepted solution]

Hi,

try below,

='TOTAL ' &

count(TOTAL {<[Shop]=,[Date]={'$(=MaxString(Date))'}, Stock-={'0'}, [SKU]={"=sum({<[Shop]=>} Sales)>0"}>}SKU)

Regards

[warfollowmy_ver]

Thank you!!!