Changing the crosstab header and supressing the calculated columns

[k_feroz]

I am trying to change the column title of a crosstab report. It works fine, but there are two additional calculated columns, whose header does now show up. Here is what I wrote in the "Display String" formula.

if month(CurrentFieldValue) = 5 then
"Budget"
Else if month(CurrentFieldValue) = 6 then
"June ITD"
Else if CurrentFieldValue > cdate('05/01/2022') then
MonthName(month(CurrentFieldValue),True)+"-" + mid(totext(year(CurrentFieldValue)),3,2)
Else
ToText(CurrentFieldValue);

I have attached an image how the output looks like. I want the calculated member header should show up. Also, I want to suppress the calculated members in each row, except when it summarizes at the group level.I have attached the report file. The file is uploaded as ".txt" as only text and image files are allowed. It can be renamed to ".rpt".

Thanks

mpawardfinancialreport-new-v9bean.txt

[k_feroz · Accepted solution]

Found the answer.