Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Say I have these two tables:
| AddressNumber | Catagory | Customer |
| 200001 | 10 | A |
| 200002 | 10 | B |
| 200003 | 10 | A |
| 200004 | 20 | C |
| 200005 | 20 | D |
| 200006 | 10 | E |
| 200007 | 40 | F |
| 200008 | 50 | G |
| 200009 | 10 | H |
And
| Year | Sales | Customer |
| 2013 | 500 | A |
| 2014 | 501 | B |
| 2015 | 502 | A |
| 2016 | 234243 | C |
| 2017 | 234244 | D |
| 2018 | 234245 | E |
| 2019 | 234246 | F |
| 2020 | 234247 | G |
| 2021 | 123123 | H |
They are associated via Customer.
What I want is a straight table that shows all customers even if I select a year in the field year.
So NOT like this:
Include a measure in the table with Set expression e.g.
Count( {$<Year= >} Customer)
So right now it is not possible to do this without using a measure?