You were close with where you were going building the title out. I used this:
"Cases from Fiscal Period " + str(lookup(attr([DischFiscalPeriod]),first()))+" Fiscal Year " +
str(lookup(attr([DischFiscalYear]),first())) + " through Fiscal Period "
+str(lookup(attr([DischFiscalPeriod]),last()))+" Fiscal Year " +
to create it. This is placed on the level of detail and set to across then down.
Tableau_maxissue AK.twbx.zip 52.2 KB
That worked great.
If you run your calculated field against the DischFiscalYear and DischFiscalPeriod as Number instead of Strings, it formats the years in my titles with comma separaters like so:
Fiscal Year 2,007 through Fiscal period......
Is there a way to tell Tableau not to format the string when it converts a number?
You should be able to change default number format to custom, then just # to achieve this.