Add Total row for table (column is not summarized)

[ZVV]

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 date with different figures and I need to see them all.

For example I have lines with 3, 5 & -7fro today. If I mark the column as "Sum" - I'll have just one line with 0.

But I need to see all the lines and have Report Total at the same time.

Thanks!

[AndresPino]

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))))

[brygwalski]

Hello ZVV,

I have found the same issue with my report. My solution was to sum the column in a measure. This will allow you to get a grand total at the bottom and still keep the data split out.

[v-caliao-msft]

@ZVV,

You could use a  table visual to display data in your table, mark as Sum, and then turn on Total.

Regards,

Charlie Liao

[Anonymous]

This worked for me!! thank you 🙂

[ZVV]

I mentioned in the question that I can't mark "Sum" - it must be marker as "Don't summarize".

In this case Grans Totals do not appear regardless of "Totals" setting.

[v-caliao-msft]

@ZVV,

If that is the case, I am afraid there is no such a option to show total row in your table visual. Thank you for your understanding.

By the way, why cannot mark it as "SUM"?

Regards,

Charlie Liao

[ZVV]

Thanks, Charlie

Regarding "why" - again, I mentioned it in my question (with some figure corrections):

>> For example I have lines with 3, 5 & -8 for today. If I mark the column as "Sum" - I'll have just one line with 0.

>> But I need to see all three lines and have Report Total at the same time.

Currently as a workaround I've added a line ID field to report and made the column as narrow as possible (so it's almost invisible) but I don't like this solution.

[hagargreif]

Could you explain how it helped to fix? 

[Anonymous]

For the ID field, you can right click on the ID column in the table view and mark "Hide in report view" --> This will not show in the report view.

[ZVV]

So as far as I understand it's just impossible to have grand total in Table if you have "Don't summarize" numeric values?

Can someone confirm that?

[Anonymous]

I also faced the same issue today, I added a card visual at the end to show totals and in tables I made as don't summarize. This overcame my problem.