Current Year Rangesum Vs Previous Year Same Month Rangesum against CY Month Year Dimension
I need to show PYTest values for Aug 2021,Sep 2021 and Oct 2021 values in Jul 2022 ,Sep 2022 and Oct 2022 i.e 3,10.5,13 above Current Year blue line(CY Monthly Lytics) which is showing 6,13 and 21. Also the Values from Aug 21-Apr 2021 should not be seen...We are taking Financial year which Starts from July and ends at June.
The PY lytics is adding Current year values 6,7,8 in its last value (last month showing April as there is no data for may and June) and showing from July 2022 onwards.
PY Rangesum was 3,11,13(Aug,Sep,Oct)
CY rangesum is 6,13,21(Jul,Sep,Oct)
As per this it should show 0,11,13 and 6,13,21 for Jul2022,Sep2022,Oct2022