Struggling to write Beastmode that reflects current MTD values
I have a column of marketing sources where I am trying to breakout individual sources to be their own individual columns, and have them only reflect current MTD amounts. I have multiple YOY and MOM % and net differences in columns that interact with that date setting portion, so changing the date setting is going to change those Period Over Period columns. I have started by writing the following calc, but I'm unsure how to write and call out those specific values in the marketing source column.
CASE WHEN ((year(`Date_Entered`)=year(curdate())) AND (month(`Date_Entered`)=month(CURDATE()))) THEN `marketing_source` END
Marketing Source is the column that contains fields like Google, Google paid that I am trying to pull out in to their own columns