Forum

Hi Michael, You definitely can't do this with a regular PivotTable. In the file attached I've inserted a measure in a Power Pivot PivotTable. My...

Hi Howard, Your question isn't clear to me, sorry. You mention a buffer in cell E1, but then refer to F1, which is an empty cell. Is this a mistake...

Hi Pooyeh, Great to hear you've found my videos helpful. I don't have anything on timelines and milestones specifically, sorry. However, you might ...

Sorry, I should have set the summarise setting to Average in the PivotTable, however, that still won't give you the calculation you want because it's ...

Hi Cathy, Welcome to our forum! Yes, you can use Power Query to get sheets from multiple files in a folder. Mynda

Hi Justin, 1. Yes, however I'm not sure what you're expecting to do with the max limits you mention. 2. If your data is split over multiple shee...

Hi Bruno, Seeing that your receipt table contains a distinct list of TransactIDs, you can use this as your lookup table. You can then create a Pivo...

Hi Benoit, Are you able to share your file? I can enter the formula in English and then when you re-open the file it will translate it to French fo...

Hi Michael, In the attached file I've created a regular PivotTable with the year on year % change, but you'll see in the Slicer that you need to se...

Hi Lea, See file attached. Note: if you add fields to the rows area in the PivotTable with the calculated field you will get the 17% applied to eve...

Hi Jessica, How about if you added a conditional column that checked if the Event column contained Pay Day AND the length of the text in Event was ...

Hi Steve, Welcome to our forum! I can't see which data validation list you're referring to. The one in column D is showing a #REF! error and the...

"The GetPivotData allows me a formula outside of the pivot and if I make changes to the pivot structure it disappears." Build a separate PivotTable to...

And adding the SUM to the condition 😉

Hi Monika, Welcome to our forum! You can use this formula in cell P5: =IF(AND(P3>=$B$5, SUM($E$5:O5)<$A$5),$C$5,0) And copy to co...