Last seen: May 16, 2025
Great to hear you've found my videos helpful! You can add a calculated field and only use it in one PivotTable. However, calculated items will be a...
Hi Saliha, In Excel dates are numbers too. They're stored as date serial numbers, so it's not as simple as identifying which values are dates vs nu...
Great to hear, Alan!
Hi, Thanks for sharing your file and video explanation. Each row label in the PivotTable acts as a filter. When you have the main category field...
Hi Kent, I don't have any tutorials on that specifically, but I found this tutorial that might help. Mynda
Hi Dieneba, Thanks for sharing your file. The good news is your PivotTables share the same dataset. The issue is that you haven't connected the Sli...
Now that we have the VSTACK function we can return headers like so: =VSTACK({"Header1","Header2","Header3"...},FILTER(....your filter formula)) ...
Hi Zaki, I agree with Jessica. I'm not sure where you'd plot the line for >5 and <1 and it be clear what it represents. It would be helpful i...
Hi Dieneba, For a Slicer to be able to filter multiple PivotTables, they must all use the same source data. If you have 3 separate sources, then yo...
Hi Kelli, Thanks for sharing the screenshot. I can see why you are confused. There are two primary Power BI tools so to speak. An online Power BI w...
Hi Alan, Hard to say as I can't see the row and column labels in the screenshot to reference it to the conditional formatting rule. Perhaps you hav...
Hi Tom, Thanks for sharing the screenshots. It must be a regional setting. You would have to switch to an English version of Excel by changing the ...
Hi Kelli, Attached are screenshots of my screen with the navigation pane collapsed and expanded (saved in one image, side by side). In the collapse...
Hi Dieneba, Let's say you have a dashboard that has multiple Pivot Charts (connected to PivotTables) that display sales data for a group of departm...
Hi Ruth, Welcome to our forum! Microsoft in their wisdom changed the name of the From Table/Range button to From Sheet. Then after much backlash...