Good afternoon all. I am on day 3 of searching the interwebs, calling my Excel guru friends and I will have not been able to figure this out, to top it all I'm on a pretty short deadline for the end product which I have yet to produce.
I want to apologize in advance if the answer has been covered in these forums maybe using different words but I myself could not find the answer and thus ask for your help.
I have a data table with plan dates and actual dates. The plan dates do not adjust. When I add the data to a pivot the totals get adjusted in a weird way. For example, there are 10 projects with January plan dates, and 16 total actual. When filtering to January (via pivot filter or graph slicer) the plan adjusts to 16 making it impossible to show when the total plan was overachieved. The plan should be 10 not 16 and for the life of me I cannot figure out why this is happening. I included a sample of the data I am looking for, the data table, and what I currently get using a pivot. I need the ability to present this via graph/slicer for easier maneuverability.
Thank you in advance.
PS. This "weird" behavior is also happening when counting actuals (actuals get counted that do not exist).
Bookmarks