I'm trying to display the number of clients impacted by a decrease in sales per article. In my report, I have a first column with article codes, a second column with client codes, quantities sold in 2023, quantities sold in 2024, and the difference.
What I want to do is display in a second report a column with article codes and a column to the right: the number of clients impacted by the decrease in sales between 2023 and 2024 for each article.
Here's my formula: =Count([Article Code]) Where ([Cumulative Difference in Quantity Sold]<0 In ([Article Code];[Statistical Article Family Title];[Representative Title];[Client Code]) In Report)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.