Hi Mynda, In fact I rather rejected the Timeline slicer, because you mentioned a few disadvantages of it in one of your example sheets. But, if ...
Hi Mynda, Thanks for looking into it. I have tried to use a slicer for the year-week periods, but it keeps a little bit more complex. For th...
Hi Mynda, I'm happy to share my current Test-file; see attachment. In tab Data I have defined cells to control the selected range: StartWeek, En...
Hi Mynda, Thanks a lot! I typed the formulas over and over agaiin, and just overlooked the double quotes that Excel (apparently) adds after closing...
Hi Mynda, I already watched that video before, but still it doesn't work. I included an example file, with the 'problem' column Declarabel in ta...
Hi Mynda, Thanks for this. I'm going to puzzle how to solve this with either GETPIVOTDATA or CUBE. Maarten
Hi Mynda, I'm still a bit confused. From some examples in the Power Pivot course I got the idea that you can bring together data from different t...
Hi Mynda, Thanks for that. Unfortunately the example in my last post wasn't fully visible: My problem lies in the rightmost column: getting som...
Hi Mynda, What I would like to do: put the Year into a filter, and the weeks in the Rows. But even dragging the Week into the Rows will only result...
Hi Mynda, W.r.t. the hierrachy: in the course I did see (?) that the parts of the hierarchy can be used separately within the Pivot tables, both fi...
I managed to create the StartDates for the CapacityWeek and CapacityMonth tables, and created Relationships to the Calender. However, functionality...
Hi Mynda, Thanks. Unfortunately in a Dutch environment all these names are different. So I had to search some time getting the right place to corre...