Can you please tell me if there is a way to show a YTD column, that only looks at the current year. I have attached my tableau workbook as well as an image of what I am trying to accomplish. The Inventory, Pipeline, and Percent on Time would be a YTD average, the Throughput rows would be a YTD Sum.
Typically YTD would work in this way: Select a Day (from a list of MM/DD/YYYY), then based on your selection, YTD value would be displayed. Since your data has several date fields. Which one should you expect?
Cancelled Date, Completed Date, Control End Date, Control Start Date, Current Date, Date, ... and so on...
please can u specify the field name?