Last seen: Apr 24, 2025
Hard to say without seeing how your data is structured and the PivotTable layout. Have you tried using just =DIVIDE(Table_Measure[isfrn], Table_Measur...
Hi Lisa, You just need to add a column to the source data and chart for the balance of 950 and change the chart type to Stacked Column. See file at...
Hi Lisa, The images uploaded, but the Excel file didn't. Please try again and wait for the grey check mark to appear beside the file size after pre...
Hi Rob, That's a lot to try and visualise and as a result, I'm not sure I completely understand the scenario. For one, I don't know where the sourc...
Hi Charles, This post covers the different merge types in Power Query and should answer your question. If you're still stuck, come back with an exa...
Hi Peter, Here is the original post and answer. Note: even with Office 2021, you still don't have this functionality. It's only available with ...
Hard to say without seeing the file, but have you tried fully qualifying the column name with the table name e.g.: =MEDIAN(Table[column]) If tha...
Hi Farah, You can use Power Query assuming your example is consistent in that each section's name is split by an underscore. If so, please see exam...
Hi Darren, Thanks for sharing your file, however it's not clear to me where the formula is that you're having trouble with as the MATCH sheet appea...
Hi Ayanna, Welcome to our forum! If you go into the conditional formatting manager you can see that the yellow format is applied to one cell: K8. Y...
Hi Darren, Welcome to our forum! Can you please upload a sample Excel file that illustrates the data layout and desired result so we can help you. ...
Hi Dieneba, I think you're overcomplicating things. "If I understand well here the dimension is the subcategory of the foreign key on the fact t...
It's because of this: "...BUT you must also have the Completion Time field in the row labels." i.e. the Completion Time field must be in the row...
Hi Richard, Dates in the row/column labels cannot be formatted as you want. However, if you also put the Completion Time field into the Vaues area ...
Hi Syed, It's difficult to answer without an example file, but you might find these tutorials helpful: Excel PivotTable Show Values As • My Onli...