Get Data: Table from Another Workbook - Include Total Row

Hi All,

I'm learning about Queries and Connections and have connected a table from one workbook to another workbook. For some reason, the Total Row from the source workbook is being formatted as a normal row in the destination workbook. Is there any way to have Excel recognize this Total Row from the source and apply it to the destination table? I could manually add the Total Row from the Table Style Options but this would double count.

Any ideas?

maybe use Table.RemoveLastN(previous step,1) then add Total Row on the result table

Thank you so much for your response!

I apologize, I am brand new to this and am just learning the syntax. I tried to reproduce your instructions but am getting an error. Here is what I have to start:

= Table.TransformColumnTypes(MyTable,{{"Column1", type text}, {"Column2", type number}})

After your instructions:

= Table.RemoveLastN(TransformColumnTypes(MyTable,{{"Column1", type text}, {"Column2", type number}}),1)

I am getting an error: Expression.Error: The name 'TransformColumnTypes' wasn't recognized. Make sure it's spelled correctly.

Any ideas?

Thank you so much, this worked perfectly!!!

You are welcome