11 Replies Latest reply on Oct 13, 2016 12:18 PM by Lisa Li

    Issue with two dates next to each other

    tanya.kanwar.0

      HI,

       

       

      I am creating a report, where in Columns I will have two dates -> 1st date will be selected by the user from the Datefilter and 2nd Date will be 1stDate -1 .

      I am seeing sales for these two dates.

      The issue is when I place both the dates in the column and Sales on the size. The bar comes of the same size with the same values for both the dates.

      However in database both have different values for sales for these two dates. How do i fix it..?

      I created a scenrio and have attached sample workbook.

       

      This is how the data is in the excel

      Order date (5th Jan 2010) -> Product category = Furniture, Product Container= Jumbo Drum, Sales = 19.97

      Order date (4th Jan 2010) -> Product category = Furniture, Product Container= Jumbo Drum, Sales = 346.52

       

       

      But apparently both show same values at the moment. I have attached the workbook. Can someone help ?