Forum

Thank you so much for all your clarification. You really helped me out here.

Riny, Velouria, OMG, putting something in the Value field (I have put FN No - Year from table 2) resolves the issue. Can you explain to me why ...

Hello to both of you, Let me start with the Velouria's reply. I do not have any value as there is no content which would require a calculation. ...

I have been experimenting a little bit and I have come to believe that in a non-pivot environment I would most likely resolve this issue with SUMPRODU...

Hi Mynda, Thanks for your reply. Your pivot table has brought me a bit closer to what I want to achieve. I did not add a separate column for the...