daleholden
Board Regular
- Joined
- Sep 22, 2002
- Messages
- 243
Hello
Cannot seem to find an answer on here unless i am poor at searching.
I bring my data into PQuery clean it and send it back to Excel.
I then run a PVTable but like all Credit Cards they run between two dates.
Mine is 19th to 18th of next month.
I am trying to show in a PVTable a table showing period.
The date between function only works on one set of months but i want to show 12 months of data for each period?
How can i achieve this i am sure it must be possible
Cannot seem to find an answer on here unless i am poor at searching.
I bring my data into PQuery clean it and send it back to Excel.
I then run a PVTable but like all Credit Cards they run between two dates.
Mine is 19th to 18th of next month.
I am trying to show in a PVTable a table showing period.
The date between function only works on one set of months but i want to show 12 months of data for each period?
How can i achieve this i am sure it must be possible
