https://community.fabric.microsoft.com/t5/Developer/Diagonal-Sum-in-Pivot-Table/m-p/798510#M20857 <P>I've created a Pivot Table in Power Query and next would like to add a column that sums the diagonals (starting in upper left). Any help would be appreciated!</P><P>&nbsp;</P><P>Example:</P><P>&nbsp; &nbsp; &nbsp; &nbsp; April&nbsp; &nbsp; &nbsp;May&nbsp; &nbsp;June&nbsp; &nbsp; July&nbsp; &nbsp; &nbsp;diagonal Sum</P><P>X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8</P><P>Y&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(3+1) = 4</P><P>Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(5+8+2) = 15</P><P>W&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(5+4+0+7) = 16</P> Fri, 20 Sep 2019 23:09:04 GMT airel2929 2019-09-20T23:09:04Z https://community.fabric.microsoft.com/t5/Developer/Diagonal-Sum-in-Pivot-Table/m-p/798510#M20857 <P>I've created a Pivot Table in Power Query and next would like to add a column that sums the diagonals (starting in upper left). Any help would be appreciated!</P><P>&nbsp;</P><P>Example:</P><P>&nbsp; &nbsp; &nbsp; &nbsp; April&nbsp; &nbsp; &nbsp;May&nbsp; &nbsp;June&nbsp; &nbsp; July&nbsp; &nbsp; &nbsp;diagonal Sum</P><P>X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8</P><P>Y&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(3+1) = 4</P><P>Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(5+8+2) = 15</P><P>W&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(5+4+0+7) = 16</P> Fri, 20 Sep 2019 23:09:04 GMT https://community.fabric.microsoft.com/t5/Developer/Diagonal-Sum-in-Pivot-Table/m-p/798510#M20857 airel2929 2019-09-20T23:09:04Z