Hello @Parvathy, if you want the Statuses to show in the same column, you will have to write the functionality for each value (Sold, Currently at Showroom, etc), in a single calculated field and the same goes for the count of each.
I would recommend using the same functionality to display the Status name you want, as well as the count. I think the contains functionality would be the best for this, I’ll link the documentation here.
Here is my suggested ifelse statement for the Status name column:
ifelse(
contains({status comment section}, "Sold") = true, "Sold",
contains({status comment section}, "Currently") = true, "Currently in Showroom",
contains({status comment section}, "Removed") = true, "Removed",
NULL
)
Here is my suggested ifelse statement for the counts column:
countOver(
ifelse(
contains({status comment section}, "Sold") = true, {status comment section},
contains({status comment section}, "Currently") = true, {status comment section},
contains({status comment section}, "Removed") = true, {status comment section},
NULL
), [Week], PRE_AGG)
I haven’t totally determined the best way to do the totals yet, it is going to be a little tough to exclude the Currently at Showroom section since these columns are being made in calculated fields. Try these two ifelse statements first and lets see if that works.