3 Replies Latest reply on Sep 17, 2018 7:33 PM by Zhouyi Zhang

    Previous week Sales

    Curious Wolf

      I have product's sales data filtered by weekend dates.If I chose a random weekend date,I need to show both the selected weekend sales and the previous weekend sales.

      How to resolve this

      If If DATEDIFF('week',min([Previous Week Date]),min([Week Date])) = 1 then sum([Sales]) end  is returning the [Week Date]'s sales instead of [Previous Week Date]'s sales because the sheet is filtered by [Week Date].

      Please find attached the sample workbook.Thanks!