Register
Log In
Unanswered
Home
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Somehow I miss something. When making an Excel-table from a datatable you can mark 'Total' in the design. But then only the total of the last column appears (and it's a subtotal, but that works good when you filter some data). I thought there was a way to easily add the totals for the other columns as well, and the same for the row totals. But kind find it (anymore).
See attached file where I explain with dataset and screenshot.
Is there an answer to do this totalling all at once?
Dashboards
June 25, 2016
Offline
Hi Frans
You can select cell N47 (where the subtotal is) and drag the little black dot (at the bottom-right corner of the cell) to the other columns to fill in the subtotal.
Another way is to select the cells C47:N47 and click the AutoSum from the ribbon.
As for the row total, if you enter a formula, it will auto fill the entire column unless that column contains any non-formula. You can also use the AutoSum method.
Sunny
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Thanks Sunny! It are the most easy things that sometimes don't come up..... I started with the copy-paste and that's not the trick here. Maybe that's why I didn't try the 'drag' solution. And for the row total: that one is indeed already the one we used, but I was thinking maybe some other solution is also possible.
This all started in a lesson, where at first (before making the Excel-table) you can autosum everything by selecting the data. When the client did this in the Excel-table (which in my opinion was a logical way of thinking) this didn't work anymore (only zero's appeared) and so we were discussing the right way to totalize columns and rows in these Excel-tables.Â
Excel always surprises me in one way or the other 😉
Dashboards
June 25, 2016
Offline
Hi Frans
If you want to sum all columns and rows in one-go, just select the data plus one extra column to the right and one extra row to the bottom.
Now click the auto sum button. This will also work for non-table.
Hope his helps.
Most Users Ever Online: 57
Currently Online: clark shao
8 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
