The below is a screenshot from Excel file. What I want to do is create the baseline Bar Chart but the issue is that the data is not available from the data source for Tableau (only the data for FY1027).
Is there a way to create a calculated field or constant to represent 6.7MM and to graph it?
Grateful for your input and advise on how to go about it.
You may want to create a Parameter
for your Baseline Spend value (6.7M).
Then use either Custom Row Grand Total
to draw a Baseline Spend Mark on a view,
or combine the two views (Baseline and FY2017)
side-by-side on a dashboard.