MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t (
  outlet text,
  billdate date,
  hours int,
  netAmount int
);
insert into t
values
  ('ol1', date '2018-08-21', 1, 10),
  ('ol1', date '2018-08-21', 2, 15),
  ('ol1', date '2018-08-22', 3, 20),
  ('ol1', date '2018-08-22', 4, 25),
  ('ol1', date '2018-08-23', 5, 30),
  ('ol1', date '2018-08-23', 6, 35),
  ('ol2', date '2018-08-21', 1, 40),
  ('ol2', date '2018-08-21', 2, 45),
  ('ol2', date '2018-08-22', 3, 50),
  ('ol2', date '2018-08-22', 4, 55),
  ('ol2', date '2018-08-23', 5, 60),
  ('ol2', date '2018-08-23', 6, 65),
  ('ol3', date '2018-08-21', 1, 70),
  ('ol3', date '2018-08-21', 2, 75),
  ('ol3', date '2018-08-22', 3, 80),
  ('ol3', date '2018-08-22', 4, 85),
  ('ol3', date '2018-08-23', 5, 90),
  ('ol3', date '2018-08-23', 6, 95);

Records: 18  Duplicates: 0  Warnings: 0


SELECT
  CASE 

    -- The label of the grand total
    WHEN GROUPING(outlet) = 1 THEN 'TOTAL2'

    -- Prevent printing the outlet on rows 2+ per outlet group
    WHEN row_number() OVER (PARTITION BY outlet ORDER BY billdate) = 1 THEN outlet 
  END AS outlet,
  billdate,
  SUM(netAmount) AS `Total1/Ho...`,

  -- This is just a silly assumption based on your data.
  -- Your actual formula might be more involved
  SUM(CASE WHEN mod(hours, 2) = 1 THEN netAmount END) AS `1`,
  SUM(CASE WHEN mod(hours, 2) = 0 THEN netAmount END) AS `2`

  -- Possibly more?
FROM t
GROUP BY outlet, billdate WITH ROLLUP

-- Get only the grand total or ordinary groupings
HAVING GROUPING(outlet) = 1 OR GROUPING(billdate) = 0


outlet
billdate
Total1/Ho...
1
2


TOTAL2
null
945
450
495

ol1
2018-08-21
25
10
15

null
2018-08-22
45
20
25

null
2018-08-23
65
30
35

ol2
2018-08-21
85
40
45

null
2018-08-22
105
50
55

null
2018-08-23
125
60
65

ol3
2018-08-21
145
70
75

null
2018-08-22
165
80
85

null
2018-08-23
185
90
95


WITH
  t AS (
    SELECT
      CASE 

        -- The label of the grand total
        WHEN GROUPING(outlet) = 1 THEN 'TOTAL2'

        -- Prevent printing the outlet on rows 2+ per outlet group
        WHEN row_number() OVER (PARTITION BY outlet ORDER BY billdate) = 1 THEN outlet 
      END AS outlet,
      billdate,
      SUM(netAmount) AS `Total1/Ho...`,

      -- This is just a silly assumption based on your data.
      -- Your actual formula might be more involved
      SUM(CASE WHEN mod(hours, 2) = 1 THEN netAmount END) AS `1`,
      SUM(CASE WHEN mod(hours, 2) = 0 THEN netAmount END) AS `2`

      -- Possibly more?
    FROM t
    GROUP BY outlet, billdate WITH ROLLUP

    -- Get only the grand total or ordinary groupings
    HAVING GROUPING(outlet) = 1 OR GROUPING(billdate) = 0
  )
SELECT
  json_arrayagg(json_object(
     '1', t.`1`,
     '2', t.`2`,
     'OUTLET', t.outlet,
     'BILLDATE', t.billdate,
     'TOTAL', t.`Total1/Ho...`
  ))
FROM t


json_arrayagg(json_object(
     '1', t.`1`,
     '2', t.`2`,
     'OUTLET', t.outlet,
     'BILLDATE', t.billdate,
     'TOTAL', t.`Total1/Ho...`
  ))


[{"1": 450, "2": 495, "TOTAL": 945, "OUTLET": "TOTAL2", "BILLDATE": null}, {"1": 10, "2": 15, "TOTAL": 25, "OUTLET": "ol1", "BILLDATE": "2018-08-21"}, {"1": 20, "2": 25, "TOTAL": 45, "OUTLET": null, "BILLDATE": "2018-08-22"}, {"1": 30, "2": 35, "TOTAL": 65, "OUTLET": null, "BILLDATE": "2018-08-23"}, {"1": 40, "2": 45, "TOTAL": 85, "OUTLET": "ol2", "BILLDATE": "2018-08-21"}, {"1": 50, "2": 55, "TOTAL": 105, "OUTLET": null, "BILLDATE": "2018-08-22"}, {"1": 60, "2": 65, "TOTAL": 125, "OUTLET": null, "BILLDATE": "2018-08-23"}, {"1": 70, "2": 75, "TOTAL": 145, "OUTLET": "ol3", "BILLDATE": "2018-08-21"}, {"1": 80, "2": 85, "TOTAL": 165, "OUTLET": null, "BILLDATE": "2018-08-22"}, {"1": 90, "2": 95, "TOTAL": 185, "OUTLET": null, "BILLDATE": "2018-08-23"}]
outlet	billdate	Total1/Ho...	1	2
TOTAL2	null	945	450	495
ol1	2018-08-21	25	10	15
null	2018-08-22	45	20	25
null	2018-08-23	65	30	35
ol2	2018-08-21	85	40	45
null	2018-08-22	105	50	55
null	2018-08-23	125	60	65
ol3	2018-08-21	145	70	75
null	2018-08-22	165	80	85
null	2018-08-23	185	90	95