Forum Discussion
abukapsoun
Post Patron
Post PatronSum of values based on filter
Hi, Need your kind support please. I have the following two tables Customer ID Customer name 1 XX 2 YY 3 ZZ Then I have another one Customer ID Value 1 20 2...
it worked by applying a filter on the page level
amitchandak
Super User
Super Userabukapsoun , As your customer table do not have all customer.
if you do not select any filter value, means all/none. If there if not filter and it gives you everything from the second table .
If you use a filter then you will get only get those value
The default is right join (1-M) with filter it is inner join
abukapsounPost Patron
Post PatronYes exactly. I tried putting a filter on the page, but it didnt work. Any idea?