Comments
-
Never mind! I think it was because I put the fields after the date field. I was able to make it work when I moved them. Thank you again for all the help!
-
Thank you so much! That worked perfectly. But now I have another question. I tried to add a couple more rows to my report (sales region and sales client) but I'm getting this error: "An issue has occurred during processing. We are unable to complete the request at this time - 'undefined'" There is no error when I take out…
-
Hi Mark! Thank you for your reply. I tried this and it didn't seem to work. I used the Beastmode you created above: CASE WHEN DATEDIFF(MAX(Billing Month New),CURRENT_DATE()) < 60 THEN 'Program Ending' ELSE 'All good' END I dragged it into filters and filtered for program ending. I have program names in my rows and I set…