Calculate total weeks sales

[Anonymous]

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 

[PaulDBrown · Accepted solution]

@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

[Anonymous]

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?