Forum Discussion
Calculate total weeks sales
I have tried several mesures and suggestions but can not figure this out. My table has date week number and daily sales.
i want to calculate or create a col;unm that totals the whole weeks sales. I have 7 week 12 entries as the week number is returned for each date entry. Please help
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
3 Replies
PaulDBrownCommunity Champion
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
- 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?