Forum Discussion
Solved
Filter from customer ruins time intelligence
Hello for some reason, when a filter is coming from the customer table, the PY calculation breaksdown. Sales gives the correct value for each customer group and year for the current yea...
Sorry for not answering. The problem was that i accidentally had made a relationship between the date table and another fact table bidirectional. Changing it solved the problem.
Without the filter from customer it looks like this :
HI Låret,
Can you please share some dummy data with raw table structures and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng