Hi Mynda, Many thanks and I've taken everything in. To be honest, although it seems that we were going round in circles (and we probably were) I w...
Hi Mynda, First a huge apology for upsetting you and I recognize that some of my questions seem contradictory – and sometimes just wrong. I really...
Hi Mynda, Don't know what was going on in my head to get Fact and Dimension tables 180 degrees wrong! I've given myself a stern talking to and hav...
Hi Mynda, I've been doing quite a lot of thinking about this and I'm really grateful for your insights and suggestions. I reproduced the pivot tha...
Hi Mynda, I completely take your point about the table structures - my reason for the Alloc[ation] table was that it is sometimes necessary to swit...
Hi Mynda, Apologies and thanks for your patience. Here it is, I hope. Pieter
Hi Mynda, I followed your advice and learned a lot in the process. I've re-worked my data into normalised related dimension and fact tables (I thi...
Hi Mynda, You're absolutely right - I do need to learn Power Pivot! As it happens, I was presented with the original table of several thousand lin...
Hi Mynda, I'm afraid I've broken it! I added a second table for club secretary details and set up a relationship on field "Town" to link the two. ...
... and a follow-up question, please! Is there any performance advantage in keeping the two formulas separate or would it be better to combine them? ...
Hi Mynda, Thanks very much for such a quick and helpful reply - really appreciated. Boy, do I have a lot to learn... Pieter