I have the data in coming like this format , however, there are additional services but there is no data present in db(ex: service 4, 5, 7 &9) thus, data didn't get pulled and table is showing these services..but my requirements is show in table all the services though there is data available or not.. can you help how to write expression to display this.
Due to data to available in db table displaying the values only where data is present in db
service | count | price | total price |
service1 | 4 | 3.5 | 14 |
service2 | 8 | 12 | 96 |
service3 | 5 | 5 | 25 |
service6 | 16 | 14 | 224 |
service8 | 12 | 6 | 72 |
service10 | 34 | 35 | 1190 |
excepted table display
service | count | price | total price |
service1 | 4 | 3.5 | 14 |
service2 | 8 | 12 | 96 |
service3 | 5 | 5 | 25 |
service4 | 0 | 3 | 0 |
service5 | 0 | 5 | 0 |
service6 | 16 | 14 | 224 |
service7 | 0 | 7 | 0 |
service8 | 12 | 6 | 72 |
service9 | 0 | 8 | 0 |
service10 | 34 | 35 | 1190 |