View My Drafts
I have a table where I have data week on week. I want to have a detail of Project who are not submitter week on week with the count. The condition is, if the project is a new to the list of not submitter then that column should be blank otherwise if its repeated more than once, it will mention "Defaulter for past 2 PEDs". This will be current week report always. Also, when we apply date filter to the table to have the current week data, the repeated defaulter column should not have impact of filter. Otherwise, the Defaulter for past PED will always show 1 PED. Below is the format of report. I am attaching the dummy data.
Hi @Krishna Nandan,You can create both output tables in PQ, illustrated in your sampe file (attached).If you require something else, please supply more details on your actual requirement.I hope this is helpful