Forum

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...

Hi Lea, PivotTables don't work like that. They don't leave cells blank, they're designed to aggregate the data based on the row and column labels. ...

Hi Michelle, Welcome to our forum! The TEXTJOIN formula is joining all characters, it's just that it can't display them all in the one cell without...

Hi Justin, Thanks for sharing your sample file. The data in the file is not clean enough to work with. e.g.: Item numbers are inconsistently e...

Hi Lea, If it's a regular PivotTable then the only way to add columns that are retained by the PivotTable is to add it as a Calculated Field or Cal...

Hi Justin, Welcome to our forum. Please upload a sample file so we can see the format of your data. Mynda

Hi Ichiha, Welcome to our forum! You can use this formula where your text is in cell A1: =TIMEVALUE(SUBSTITUTE(SUBSTITUTE(A1," hours, ",":"),...