Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Above is my dataset. now when i apply filter on Col6(list Box) let say value "33" the table shows 2 records . Cuz the col6 has 2 records in table. But instead i need 3 rows . i.e 2 rows matching value 33 and also the last records if col4 is not null.
Maybe something like
Sum(Col1) + Sum({<Col6={"=getselectedcount(Col6)>1"} ,Col4={"=max(Col4)"},Col6=>} Col1)