In chart (Pivot) I have dimensions fruit and warehouse, week and day. And data from table stocks with columns stock and sale. I want to see when I choose dimension per week data stock must show only 1 day (example Sunday’s data) . When I choose next dimension per date In Pivot data stock must show every day.
