Forum Discussion
INDEX MATCH MATCH Dynamic Named Lists
Can you at least repeat the data label in the pivot table?
please see the animated gif on how to enable the setting of repeat data label in pivot table.
If you can do that, then I may have a solution for you with formula.
simply putting this formula in J11 of the attached workbook and dragdown and right.
Plz see it in the attached workbook.
=IF(RIGHT($H11,5)<>"Total",SUMPRODUCT(($C$11:$E$29)*($C$10:$E$10=TEXT(J$10,"MMM YYYY"))*($A$11:$A$29=INDEX($H$11:$H11,MATCH(REPT("Ω",255),$H$11:$H11)))*($B$11:$B$29=$I11)),"")
Can you at least repeat the data label in the pivot table?
please see the animated gif on how to enable the setting of repeat data label in pivot table.
If you can do that, then I may have a solution for you with formula.
simply putting this formula in J11 of the attached workbook and dragdown and right.
Plz see it in the attached workbook.
=IF(RIGHT($H11,5)<>"Total",SUMPRODUCT(($C$11:$E$29)*($C$10:$E$10=TEXT(J$10,"MMM YYYY"))*($A$11:$A$29=INDEX($H$11:$H11,MATCH(REPT("Ω",255),$H$11:$H11)))*($B$11:$B$29=$I11)),"")
Thank you for your response, although the formula was a bit confusing, it got the job done - you taught me a valuable tip on how to force the PivotTable to repeat name labels, that came in much more useful than you can imagine, thank you!
You are welcome. Thanks for your feedback.