Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SUM OF SUM Group By

I have summed [QualityHold1], [QualityHold2], [QualityHold3], [QualityHoldElse] as 'QH123E' which gives me a record of each value for the Product value, can I now get a sum of those 'QH123E' values?  Would like to see 'P1197' as PRODUCT, 167.437 as 'QH123E'

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Refer this formula.

     

    SELECT PRODUCT,SUM(VALUE) FROM Table_1 GROUP BY PRODUCT

     

     

    Best Regards,

    Jay

4 Replies