Forum Discussion
Add Total row for table (column is not summarized)
Hi I have a number column in Table report. I don't need to Sum() this column (marked as "Don't summarize"), but I still want to see Total sum for this column. I have several lines for each d...
Hi All,
im trying to create a calculation that sum the total of the previous week into the current week
week 11 has a total of 9,884 and week 12 has total of -49229 . As result, week 12 should Be -39,345. Please see my chart below.
| Pull Date | Old Feedstock | File Type | WK11 | WK12 | WK13 | WK14 | WK15 | WK16 | WK17 | WK18 | WK19 | WK20 |
| 3/11/2024 | BCDMS | Total | 9,884 | (49,229) | 202,540 | 5,274 | (33,926) | (104,368) | 45,701 | (14,174) | (45,307) | (72,729) |
| 3/11/2024 | BCDMS | Demand | (237,725) | (49,229) | (114,920) | (49,400) | (89,482) | (104,368) | (172,995) | (121,759) | (95,044) | (72,729) |
| 3/11/2024 | BCDMS | Incoming POs | 317,460 | 54,674 | 55,556 | 218,696 | 107,585 | 49,736 | ||||
| 3/11/2024 | BCDMS | RPM | 247,609 | |||||||||
| 3/11/2024 | Total | 9,884 | (49,229) | 202,540 | 5,274 | (33,926) | (104,368) | 45,701 | (14,174) | (45,307) | (72,729) | |
| (39,345) | 153,311 | 207,814 | (28,652) | (138,294) | (58,666) | 31,527 | (59,482) | (118,036) |
this is the calculation that im using. but the formula is adding carry over all the categories. I just want the total
Stock on-hand Total =
CALCULATE(
SUM(Coverage[New Qty]),
FILTER(ALLSELECTED('Calendar_Dax'[WeekNum]),
ISONORAFTER('Calendar_Dax'[WeekNum], MAX('Calendar_Dax'[WeekNum]), DESC))))