Hi Team,
I want to create a calculated filed name called "Project Status" based on below criteria , could someone please help.
1) If all ( Dev,Preprod,PRod,Decom) status moved to done then make Project status as "done"
2) If all cancelled make project status as "Cancelled"
3) if all contains not started then make project status as "not started"
4) if anyone contains in progress make project status as "Inprogress"
i have attached the sample Excel sheet.
3 answers
hi @Aj Pabba ,
Its quite simple. You need to create a calculated field with the below logic:
Its easier as well as time-saving, in comparison to the pivot solution. Attaching the tableau file for reference as well.
