Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
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.
@ZVV,
You could use a table visual to display data in your table, mark as Sum, and then turn on Total.
Regards,
Charlie Liao
This worked for me!! thank you 🙂
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.
@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
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.
Could you explain how it helped to fix?
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.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |