Forum Discussion
Syndicate_Admin
4 years agoAdministrator
Filter with Criteria
Dear good morning I hope you can help me. I have to report sales by criteria i.e. mth is period 1, qm are periods 1, 2 and 3, as shown in the Criterion table, the periods are associated with the ...
- Anonymous4 years ago
Hi jminanoc ,
Try to change the direction of the relationship to both, so that the filter can filter correctly.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
4 years agoSuper User
Syndicate_Admin , No access, applied for it. But is there a table we have Values for QM - 1,2,3 and QM-1 = 4,5,6
Then we should be able to display
but seems like that filter and table with values are not interacting
Syndicate_Admin
4 years agoAdministrator
Hello, thanks for the review, actually if it is all, in the Criterion table are the periods for what you indicate and in the period table is the date associated with the period, and in the data table is shown by dates, the relationships are fine.