Forum Discussion

athul00000's avatar
athul00000
Frequent Visitor
3 years ago

How to remove a table only from the total columns

hello Team, 

 

Can you please help to how to remove the marked from a table. I just need to remove the Status column from both the Total column and Total Rows.

The formula for Status used is 

Status = IF('SO Report'[fl_TypeDay] = "Working Day (Sales)", "📗", IF('SO Report'[fl_TypeDay] = "Sick Leave", "➕", IF('SO Report'[fl_TypeDay] = "No Sale Day", "📕", IF('SO Report'[fl_TypeDay] = "Day Off", "❌", IF('SO Report'[fl_TypeDay] = "Training Day", "📚", IF('SO Report'[fl_TypeDay] = "Holidays", "🟣", IF('SO Report'[fl_TypeDay] = "Administrative Day", "🟫","")))))))