![]() Play around with some different data and functions to see what you come up with. ![]() I am not going into these in this blog, but this should give you some ideas to start experimenting with. There are other functions that you can use within the Subtotal Function such as: Max, Min, Product, Count Numbers, Standard Deviation, Standard Deviation for the Population, Variance, and Variance for the Population. By clicking the numbers in the top left I can reduce my file so that all I am looking at is my subtotals, I have highlighted all of my subtotals to make it easy to see what I have done. Here is what we get (the newest is highlighted in blue.)Īs you can see all of my subtotals are here for easy access and use. We will repeat our steps for setting up a subtotal, I am adding in the average of the weight, destination code and discount. Now let's add a subtotal for another column without deleting our existing subtotals. I now have the totals of the costs and the number of Packages in each shipment. ![]() I highlighted the first Subtotal results in green the Count Subtotal I just completed in yellow.
0 Comments
Leave a Reply. |