Hi everybody,
maybe it is better in english.
I have a problem when I want to ignore specific filter.
I have 3 tables
- SalesFacts
- Customer
- Calender
The salesfacts-table is the center of a star-scheme and connects the other two tables
(In real the setting is much more complicated but I'm trying to simplify it here.)
So what I want ist to show all customer despite what I click on the calender.
I tried allready the functions aggr() combined with only() like this:
aggr(only({<cal_year=>}customer,customer) ------ and some other variants
but it doesn't work.
Can somebody help me?
Thanx a lot!