Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a bar graph where I need to add 'YTD' at the end of the fiscal year: it should be something like 'FY20 YTD'. See attached screenshot of the bar graph.
Can anyone advise?
Perhaps a calculated dimension, something like:
=FiscalYear & If(FiscalYear = MaxString(TOTAL FiscalYear), ' YTD', '')
Replace FiscalYear with the correct field name.
Click on the dropdown at your chart properties Fiscal Year Dimension.
At field, click on the fx and try this:
=[Your Fiscal Year Dimension]& 'YTD'
It shows YTD for all the fiscal years.
Hi
use this in your dimension field
=[Fiscal Year]& ' YTD'
thanks
It shows YTD for all fiscal years. I am looking to show YTD only for FY20 and not for others
Perhaps a calculated dimension, something like:
=FiscalYear & If(FiscalYear = MaxString(TOTAL FiscalYear), ' YTD', '')
Replace FiscalYear with the correct field name.
FANTASTIC!!. Thanks a ton!
=If(Year='2019',Year&' YTD',Year)