Hi All,
I having 2 Years data. i need to show last 8 weeks data based Selection of Week. when i selecting particular week i shows sum of 2 week data i/o current year Data.
For ex. If i have data of Year 2019 & 2020 and selecting week 26 & Year 2020, my bar chart should show data week 19 to 26 of 2020. but is shows sum of 2019 & 2020.
May be try this
vMaxDate: =Date(Max(DATE))
vPrior8WeekPeriod: =Date(RangeMax(vMaxDate - 56, Min({1} DATE)))
=SUM( {<DATE={'>= $(vPrior8WeekPeriod) <= $(vMaxDate)'}>} [Amount] )
can you please post some sample data as well as your expected result to test with?
thanks
Marco