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...
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.