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?