Forum Discussion
Calculate total weeks sales
Anonymous
By the looks of it you are actually getting the sum of sales by week (see second column: "Week Totals"). So what is it you are after?
If you create a table removing the Day column (and possibly the "daily totals Mes") you will get a table with only one Line/value per week.
Or use a matrix visual instead of a table visual
Community ChampionAnonymous
By the looks of it you are actually getting the sum of sales by week (see second column: "Week Totals"). So what is it you are after?
If you create a table removing the Day column (and possibly the "daily totals Mes") you will get a table with only one Line/value per week.
Or use a matrix visual instead of a table visual
The Column ‘week totals’ is only returning the daily sales and not calculating the whole weeks sales in essence I need all 7 entries with the same week number to be calculated to make a total for that fiscal week. The week number recycles every year so will have to be separate for each fiscal year.
- PaulDBrown
Anonymous
Ok... so what is your model structure? What column is the daily sales in? What relationship does your dCalender table have with your sales table?