Why don't you use slicer to filter the PT. You can refer here for more details on slicer. There are many more articles on MOTH's blog on t...
Something like this?
Hi Brant Glad you got it sorted out. Just curious to know why you move the newly entered Current cost in row 3 down to the Last cost in row 4. ...
Hi Chris How you create the dashboard is up to individual preferences. I usually have "pretty formatting" on them like images etc as the boss li...
Hi Brant You can give this a try. Just select any SKU and click the Move Down button. I assume that you want to move the entire selected row ...
Hi Kevin Thanks for your feedback. I am only able to test based on your sample data. If there are other scenarios, then do post them for us to t...
Hi Julian You have only reversed the Primary Horizontal Axis. You will need to display the Secondary Horizontal Axis and reverse it as well. ...
Hi Deroq Try using COUNTIFS() instead of COUNTIF() You can refer here on how to use COUNTIFS : Please attach a sample workbook for us to tak...
Hi Chris When creating any dashboard, I have a few guidelines that I will follow: 1) Output will determine the input. What your audience want...
Hi Kevin Agree!! Try this if the dates are not in sequence: =LOOKUP(2,1/(($A$2:$A$6=$A2)*($C$2:$C$6=$D2)),$B$2:$B$6)
Hi Jonathan You will need to create a helper column in your data. Refer attachment for an example. Good luck. Sunny
Hi Kevin You can try this formula. The assumption is that the latest ID for each group is the last transaction. It doesn't look at the dates. ...
Actually when I saw the 1st post, the first thing that came to my mind was to use Conditional Formatting as it will allow me to check the category in ...
Hi Todd You can try using Data Validation with an Event macro to trigger the display. My example require you to define the selection and their r...
Hi Jonathan What is your expected result? Have you tried selecting the Base Field as Years instead on Date?