Forum Discussion
athul00000
3 years agoFrequent Visitor
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", "🟫","")))))))
2 Replies
- athul00000Frequent Visitor
Also i need to keep the Sales columns and Shift column in the Total section