title: Summing values based on a group by AS WELL as all of them?
body: <p>If I have at table with, say 10 columns. 8 columns of data and 2 columns (1 and 2) as an identifier.</p>
  
  <p>I would like to calculate "the result" for the 8 columns, for every possible scenario of col1 and col2.</p>
  
  <p>Assume distinct(value) col1 gives {A,B,C} and distinct(value) col2 gives {D,E,F} I would like to sum up the data (any of the 8 columns) GROUP'd BY:</p>
  
  <ul>
  <li>A,D </li>
  <li>A,E </li>
  <li>A,F </li>
  <li>A,(All of col2) </li>
  <li>B,D </li>
  <li>B,E </li>
  <li>B,F </li>
  <li>B,(All of col2) </li>
  <li>C,D </li>
  <li>C,E </li>
  <li>C,F</li>
  <li>C,(All of col2) </li>
  <li>(All of col1),(All of col2)</li>
  <li>D, (All of col1)</li>
  <li>E, (All of col1)</li>
  <li>F, (All of col1)</li>
  </ul>