Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I put this expression to count Users who made orders in 2012 and 2013:
count({<Order-Year=2012, Order-Year=2013>}DISTINCT UserPK)
but it doesn't work, the second condition is not considered.
plz help
Try this
count({<UserPK=
p({<[Order-Year]={'2012'}>})*p({<[Order-Year]={'2013'}>})
>} DISTINCT UserPK)
help plz ![]()
I need common users in 2012 and 2013
@Mr. Eugeny Ilyin it works
thank you soooo much everybody