Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need which country are use the product both year(2000 and 2001) in set expression logic
year |
Product |
country |
2000 |
P1 |
India |
2000 |
P1 |
usa |
2000 |
P1 |
uk |
2001 |
P1 |
India |
2001 |
P1 |
Usa |
2001 |
P1 |
Uk |
2001 |
P1 |
japan |
=count({<Country={"=count({<Year={'2020','2021'},Product={'P1'}>}distinct Year)=2"}>}Distinct Country)