Forum

This happens with bar charts. You can either sort the PivotTable in ascending order or format the chart axis and under Axis Options, check the box 'ca...

To add a slicer to an existing PivotTable, select a cell in the PivotTable and then go to the Insert tab or PivotTable tab > insert slicer. That wa...

Hi Sherry, Try this in cell C2, then copy down: =INDEX(Sections!$C$2:$C$8,MATCH('Section List'!A2&'Section List'!B2,Sections!$A$2:$A$8&S...

Hi Jessica, I'm not sure what you mean by 'how the tables use the query'. What tables? In the first example I'm not creating a dynamic variable....

Hi Richard, You can use the number grouped data in Power Query technique. Mynda

Hi Ryan, Welcome to our forum! Your conditional formatting appears to be working correctly to me. Your dates span 2020 through to 2022, so you'l...

Hi Jen, Please upload an example file with your before and after views of your data. Please ensure the query in the file is not getting the data fr...

Hi Peter, The FILTER function doesn't return headers, as you've discovered. You would need to use a different formula for this e.g.: =Table1[#He...

Hi Urmas, Thanks for clarifying. You can use Power Query to number rows grouped by ID, then Unpivot and append the number, before pivoting back. Se...

Hi Tim, Taking AC count as an example: =COUNTIFS($C:$C,C4,$D:$D,D4,$E:$E,"AC") In English the formula in cell F4 says, count the number of re...

Hi Joseph, Welcome to our forum! Your LAMBDA version of the formula is not the same. Your INDEX is: =INDEX(A2:A22,SEQUENCE(ROWS(A2:A22)/3,3))...

Hi Sufinah, Welcome to our forum! When you use the data model you cannot add calculated fields and calculated items as these tools are for regul...

Hi Urmas, Please upload an example file that illustrates your desired result. Your explanation is difficult to follow, especially since I don't kno...

Hi Urmas, The correct layout for your data is your 'current table'. From there you can use a PivotTable to group the rows with the same ID into a s...

Hi Kevin, If you remove the Rekeningnr column and rows containing fust, fruit and totaal inc btw, before pivoting then the issue is resolved. Try i...