Plz see attached wrkbook, 2nd Sheet "Chart 1 (2)".
- Updated the Calculation for "Current Year Sales", created new Calculated field - "Current Yr Sales", used 'NULL' instead of '0'. Used this Cal Field in Viz instead of "Current Year Sales"
- Removed "Filter Fiscal Week YTD" from filter shelf
Now Capturing Sales data for complete 52 Wks. Hope this helps.
CL_v10.5_52wk_v10.3.twbx 557.8 KB