Crossfilter doesnt work

[Dajopa]

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.

[Dajopa]

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.

[Mahesh0016]

@Dajopa Please can you share your Expected result? Thank You.