Forum Discussion
Crossfilter doesnt work
Hello,
I am facing issues with crossfiltering two tables. Table 1 is a fact table (OppLineItem Schedule) and it includes a schedule date column. Table 2 is an autocalendar table. The relationship is biderectional and each table filters the other date well (images 1 and 2).
The issue is that the measure revenue schedule is only filtered from table 1 and my intent is to show the result in a matrix table (image in the bottom). The totals are correct, but the same value is repeated in each cell, which is wrong.
Many thanks for your support.
2 Replies
Anonymous Please can you share your Expected result? Thank You.
The expected result should resemble below snapshot.
Row reading: a deal closed in one year will generate revenue from current to upcoming years. For instance, deal closed in in 2021 will generate revenue until 2023 in a total of 100
Column reading: revenues in 2023 come from deals closed between 2021 till 2023 and it amounts to 175.
Hope is now clearer.
P.S.: in my first post, the year is the same in the headers (2021), which is wrong. It should also be 2021-23 both in row and column headers. It reflects well the issue, though.
Mahesh0016 and all, thank you.
