Forum Discussion
KeenanU
Nov 05, 2021Copper Contributor
Creating a Chart with grouped data sums
Working in Windows 10, Excel Version 2110. I am trying to setup a sales log for a foam shop that sells foam for seat cushions and other applications. I have no experience working in excel so i need ...
Riny_van_Eekelen
Nov 05, 2021Platinum Contributor
KeenanU I believe you can use pivot tables for this, but it goes too far to give you a step be step instruction here. Plenty of good tutorials are available on line. Just google "pivot table excel".
When you talk about "thickness", I assume you take about "height". A small pivot table can easily make the summary you described. Sum footage for each thickness and sort in descending order. See attached.
You loose me when you write "and how it stacks up to all other thicknesses (i.e. total volume of all 5" thick foam=120BF, total of all 6" thick=300BF, 7" thick=254BF etc.)". BF as in Board Foot?? Did som guess work in the attached file.