Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to make an expression where new customers are count based on 3 criteria which need to be met:
- no sales in previous year (=2022)
- sales must be more than 1 article
- total sales must be bigger than 20 pieces
The dimensions are customer / article / sales / month / year and I also would like to see the development per month in 2023.
Thanks in advance for your help!
Count({<Customer=e({<Year={"2022"}>})>*<Customer={"=(Sum(Sales)>20)"}>*<Customer={"=(Count(Article)>1)"}>}distinct Customer)
Count({<Customer=e({<Year={"2022"}>})>*<Customer={"=(Sum(Sales)>20)"}>*<Customer={"=(Count(Article)>1)"}>}distinct Customer)