3

enter image description here

The results I want

enter image description here

Please Help Me, Thanks for attention.

Tim Biegeleisen
  • 502,043
  • 27
  • 286
  • 360
Endi Nurcahyo
  • 31
  • 3

3 Answers3

4

You can use group by with rollup along with ifnull:

select ifnull(customer, 'Total') customer, sum(qty)
from yourtable
group by customer 
with rollup
sgeddes
  • 62,311
  • 6
  • 61
  • 83
0

You may do it this way (syntax as per SQL Server): 

select Customer,sum(Qty)
from whatevertable
group by Customer
Union
select 'Total' as Customer,sum(Qty)
from whatevertable
Samarth Patel
  • 1
  • 2
0

In Pentaho Kettle (PDI): Drag two hops from a step, and make sure you choose 'Copy'. One of the output streams can be used to aggregate on Customer level, the other one can be used to get a Total aggregation. Then use an 'Append streams' step.

matthiash
  • 3,105
  • 3
  • 23
  • 34