Comments
-
I am using text in Fiscal Period For Eg : FY18Q1
-
concat(SUM(case when `Latest` = 'Y' then `Outbound Traffic` end),' ','Latest Quarter',' ','-',' ',`Fiscal Period`) I used the code in MYSQL and could get the required result and tried to do the same using beast mode to get the summary number but failed.