Forum Discussion
Pivot Table Question
MikeM Difficult to diagnose without seeing your file. Can you upload a sample file with say a hundred rows of data spanning, say November 2020 through February 2021. Remove any confidential information, but leave the dates as you have them in your actual file.
- Thanks Riny_van_Eekelen- Just added example file 2:21 EST
MikeM Not sure I understand. You indicate that you expect to see three months for the first item in the PT. When I filter cost centre 12345 for USER 1, I find only one entry for 23 March 2020. Why do you expect to see the months of Dec 2020 through Feb 2021?
I recreated a PT resembling yours, filtering dates (right-click on a month row header and select "date filter) for 1 Dec 2020 through 28 Feb 2021. It doesn't seem to be a very meaningful PT to me, but perhaps it is to you. Let me know if this is what you had in mind. See attached (MASTER DATA). But perhaps the PT in the other file makes more sense.
- Thanks again Riny_van_Eekelen: Target consecutive months are 12/23/20, 1/23/21 and 2/23/21 (past three months). There is data for all three months within the data set. Here's the goal: "Who hasn't used their mobile phone within the last three CONSECUTIVE months by cost center#, device and name?" Have a look at "REV 2" where I placed some screen shots from an older report I got working (somehow...). Names are blotched out in red.
- Ok yes standby
