Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ask two filters simultaneously.
Hello!
(sorry I do not speak in English )
Try to set two filters at the same time , only one works . The situation is perhaps complicated by the fact that the report needed to compare data for different time periods (years) .
first filter :
sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'}> } if (Day = DAYIsland, QUANTITY))
- Working correctly.
but if I add it to the second filter , output, over the past year - the filter does not work on the dishes - as if it is not.
sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'}> } {<Year={"$(vPrevYear)"}>} if (Day = DAYIsland, QUANTITY))
For several days, I can not understand how to solve it . Thanks in advance !
Thank you. Tried all options - but does not believe. (shows or zeros or dashes)
Thank you. But shows dashes
Does not work to use two filters .. can someone that is working examples please ..