J- here is an example: we'd like to see the grand total and quarterly totals CFed

That would be great

today, when you write a case statement like case when 1=1 then 1 end you will get a script error (because there is no space after the "e" in case) in order for this to work, you need to write it as follows: case when 1=1 then 1 end or you can put the space after the "e" in case explicitly. This also happens with union and…