Hello, I hope somebody can point me in the right direction as I have no clue what formula to use or even what logic to start with.
I have two columns in my spreadsheet where I can enter values, these values are the name of the fixed product types used (B1, B2, B3, D1, D2, D3) and the other is the amount of product types sold. So I can enter eg: Product Type B1 - sold one time and so on.
No I also have an "analysis" of these products types in the same sheet and need to show the amount per product type sold (in %) and it should show the absolute value in one column and the relative value in another column. Capture.JPG
Not sure if the name of our product types interfere with anything in xls, but like I said before I don't even know where to start and what relations I have to combine, any hints are greatly appreciated, Thanks in advance
Bookmarks