Need help in renaming the values of column 'Status' based on condition
So if the filter chosen is Asia the status remains same but when filter changes to Europe then the values for status changes from
'In review' to 'A' and all other status which have cancelled value = 'Yes' , will come under 'A' and will sum the values (here example In review + not started + in progress = 4+5+7 => output: A = 16)
and done to 'D'
Please find the sample data and desired output
Thanks
Hi Gauri,
how about this?
In this way, calculated status will always (regardless of Location filter) show 'A' or 'D' in Europe, so that I reproduce desired output. If you want to show original status when you select multiple locations and show A/D when you select only 'Europe', you will be able to achieve it by Set. Please find attached workbook.
