i have a sales measure. When dragged to the coloumn pane and date into row pane. sales becomes sum(sales). so i moved the sales measure to dimension. It shows different values that are not my DB. i have only one value for particular date but it shows around >10 values.
I want to show the sales values as in DB. Not sure where its coming from.