Hi All
I want to build a formula in column E, which would be looking at a pivot table, what i want is in E4,E7 & E10 if, column a (corresponding cell, so in this example "B4") = gross margin then the formula is net sales amount/actual sold qty, and it looks at the net sales amount and actual sold qty relating to that Gross Margin.
I have tried various ways but can only get it to look at the whole column rather than the cells i need, again example i need a gross margin % for product a, b, c, and so on.....
any ideas???
Book2.xlsx
Bookmarks