title: Adding a table column to grafana table
body: <p>I have three queries that each perform a SUM on my mssql database. I want all three of these SUM results visible at the same time in the same Grafana table, so I SELECT them AS 'cash' and have grafana perform an outer join on 'cash' to get them all into the same column.</p>
  <p>What I want to do, is add another column to the grafana table called 'department' so I can put the department the figures are relevant to in the same row as the figures.</p>
  <p>Below find an edited screenshot (my edits in red) showing more or less what I'd like to acomplish as an end result.</p>
  <p><a href="https://i.stack.imgur.com/A48dG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/A48dG.png" alt="Edited screenshot showing my desired outcome" /></a></p>
  <p>I've looked at the grafana docs and tried a rows to fields transformation (<a href="https://grafana.com/docs/grafana/latest/panels/reference-transformation-functions/" rel="nofollow noreferrer">https://grafana.com/docs/grafana/latest/panels/reference-transformation-functions/</a>) but that seems to need more than one field already in the table for it to work. I've also looked at the docs for the table visualisation (<a href="https://grafana.com/docs/grafana/latest/visualizations/table/" rel="nofollow noreferrer">https://grafana.com/docs/grafana/latest/visualizations/table/</a>) as well as the other visualisations to see if any would fit my needs.</p>
  <p>Is what I want to do possible in grafana, or am I using the wrong features to try and achieve it?</p>