![]() ![]() What I am trying to show is how many units each sales rep has sold for each product on a weekly basis. I have seen where some people have suggested putting multiple versions of the GETPIVOTDATA into the formula bar to seek each date individually and add them I really would like to avoid putting 7 versions of this in each cell because I actually have to replicate this formula into over 3000 variations on different sheets in this workbook, which will be a nightmare on my file size. ![]() I do have a data range setup with columns for start dates and end dates for the Weekly ranges I need to separate. I need help/guidance with changing the "Date Sent" reference in this formula so that it will look for a date range, or a march the values in a given cell range. So far I can only get the formula to reference one date at a time I need the GETPIVOTDATA formula to reference information that falls within a date range. Has this been resolved? I am having this problem as well.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |