Hi Folks,
I have this dummy data set about the organizations making changes in their status and as they make changes we record it in our data set, I have 2 filters organization name and change date.
I want to achieve when I select any month-year from date filter then from that selected month-year value all the previous record to organizations should appear.
e.g. Org E has made many changes since Aug-23 till Feb-24.
if I select Feb-24 then its all previous records should appear in the view and not just single record for Feb-24, similarly if I select Dec-23 then its records from Aug-23 to Dec-23 should appear.
I am stuck at this point.
I appreciate your help.
I have attached the workbook, kindly look into this.
Thanks,
Hi, @Imran Shaikh
Are you looking for something like attachment?
please confirm.
Creates a parameter from a date and filters and displays items up to the date of the specified parameter.
<result>
<parameter>
<calc>
<remarks>
However, if you use dates as parameters, all dates other than the specified department will be displayed in the list.
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
