mbottai
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
Passing Date Filter into Pivot Formula
Hello! I was wondering if anyone has passed in a date parameter into a Pivot Table Formula before. If so, how best can I accomplish this? I have a begin count of employees and end count. There is a count for every day and this report can be run off of any date range. I want to see the Begin Count on the min day that is reflected in the dashboard filter. For the End Count I want to see the amount based off the max day in the dashboard filter. The formula below is counting each employee where Measure Reason is either begin count or end count and the last piece is where I want to add in the min/max date from the Date dashboard filter. Any thoughts or ideas would be greatly appreciated!Solved2.6KViews0likes2Comments