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 ?
Sorry, I didn't look closely at the link I shared. That doesn't seem to be what you're looking for.
If you edit the parameter and have it show all date values instead of a list, would that work?
-Lisa
