Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I'm trying to filter my data in the expression as example below:
Sum({$< Year = {"2010"}>}ABC)
This works fine. However, when I try to add another filter I just can't seem to get it right... I've tried many variations of bellow:
Sum({$< Year = {"2010"}>} and {$< Customer = {"AAA"}>} ABC)
(I want to show only ABC values where the Year is 2010 and Customer is AAA)
Is there any way of doing this? I belive I'm just not using the correct syntax.
Thanks in advance!
Try Jannemannen,
Try something like this:
Sum( {$<Year={"2010"}, Customer = {"AAA"} >} ABC)
Hi,
Try this, this should work.
Sum( {$<Year={2010}, Customer = {'AAA'} >} ABC)
BTW.. New look & feel of the community is owesome..!! I like this.. (nope)..Double like
- Sridhar
Thanks for the quick respone.
With your input I managed to solve my problem using the folloing:
Sum( {$< Year = {"2010"}, Customer = {"AAA"} >} ABC)
Thanks again