Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
as per the current diagram and set expression, only credit and debit value should change but Other values should be the same for all dates ( regardless of any selection).
I have tried the set expression like :
IF(lob='Credit',sum(value),
IF(lob='Debit',sum(value),
IF(lob='Other',sum({1<Date=>}value))))
but its not working as only 10/29/2018 having Other as lob all other dates dont have other as LOB.
when i should select any date other should display with constant date.
Try to share a sample app to demonstrate your issue and expected output.