In My QV Dimension Field is State,DistributorCode,RouteName,RetailerCode,Brand and Expression Field Is RepeatOrder and NewOrder
RepeatOrders Means If We Select FromDate='20 Aug 2014' and ToDate'30 Aug 2014' Then Days Diff is 10 and 10 Days Previous Date for FromDate is '10 Aug 2014', when 10 Aug to 20 Aug between Retailer given Brand Order is also Same Retailer Given Same Brand Order in 20 Aug to 30 Aug Then It Called Repeat Order Other Than Called NewOrder for Given FromDate and ToDate.
When We Expand On Retailer Level Then Give It right answer But When we Collapse On Distributor Level Then It Give All order is NewOrder we work Something Wrong Please Help
