Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
antonrus
Contributor III
Contributor III

Ask two filters simultaneously.

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 !

12 Replies
antonrus
Contributor III
Contributor III
Author

Thank you. Tried all options - but does not believe. (shows or zeros or dashes)

antonrus
Contributor III
Contributor III
Author

Thank you. But shows dashes

antonrus
Contributor III
Contributor III
Author

Does not work to use two filters .. can someone that is working examples please ..