i have a Dashboard like mentioned below with Year as global filter.
My Requirement is i need to show YTD and PYTD line son the sheet3 based on year selection.
Quantity should show for the selected year, but i should show 2 lines for the selected year and previous year.
Can any one help me how to get this??