![]() ![]() The above output is perfectly matching with the Pivot Table report. With the above formula in use, the result will be as below. I hope, now, you can read the above formula. We should Sum column B as it contains the filled diesel quantity in Gallon. If you check the Pivot Table Report at the top of this page, you can understand it. We need to summarise or group the data based on vehicle numbers. ![]() In the above formula, column C contains the vehicle numbers. Please refer to the demo data on the top.įormula: =QUERY(A2:C16,"SELECT C,SUM(B) GROUP BY C PIVOT A") Step 1 – QUERY Formula to Generate Pivot Table Like Summary Report Please follow the link if you are not familiar with using Google Sheets Query Formula – Learn Query Function with Examples in Google Sheets. QUERY formula # 4 for Grand Total on the Right Side Bottom Corner (value 1918 above) of the Summary Report. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |