Base on my attachment above (i took the screenshot from video 7.09). i saw there is the "total budget" formula was set in query, by sum up the entire "budget" column").
Suddenly i have a question in my mind - if there is a way that Power Query could help me to auto display the total sum of budget at the bottom of last row in "budget" column column after transform into excel template? Currently, i am putting "sum" excel formula manually in excel spreadsheet, after click "refresh" at each time.
Hi Tan,
You can turn on the 'Totals' in Excel Tables via the table tab in the ribbon. Do this in the table that loads into Excel after you click 'Close & Load'.
Mynda
apologize for being new here and not really catch on how to turn on "totals" in excel tables..Does it mean auto sum function in excel..wonder if you could quick demo here :-)....thanks again first for your reading time
Hi Tan,
It's dead easy and pretty self explanatory if you just turn them on and select the cell containing the total you'll see it has a drop down with options and will show you the formula.
You can also see it explained in this post on Tables and Structured References under 'magic trick # 2'.
Mynda
