I've been working on this object for a week now and still cant get it right. All lines are working just fine except for the last line where it should filter the pivot field "Month" into the current month and previous months. I'm trying to have an output of less than or equal to the current...
I need to be able to create a pivot table from a selected range, manipulate the style, filters, data, etc. It would a great help if someone could clarify this for me. Thanks!
Hello,
I am looking to create a pivot table that calculates max date.
Right now I have a code that creates a pivot table, and I can build the dates as columns however I want to know the distinct user and the max date correlated to them.
Please find my current code below.
Currently it is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.