Greetings all,
I am done with my dashboard however the stakeholders have asked for me to only show the rows with the Max "Beginning of stage date" showing per Product_ID just as in Table#2 in excel sheet attached.
However, when they click on the Product_ID to filter it by the Product_ID name, they want all the rows to show from table#1 in the excel sheet attached.
I have calculated the Last_Stage_Name and the Max_Date fields in the load script.
Any help is highly appreciated!