Hi,
I have requirement where my dashboard has incremental load and picking up latest day data. I need to build a table which shows total net for 2nd friday of previous months and for current month is if it 1st friday it will show sum of 1st friday and if its 2nd friday it will show sum for 2nd friday. for 3rd and 4th friday it should still show 2nd friday for current month.
Attaching qvw with test data. and expected output is attached.
Thanks you.
