Can anyone help me Pivot this data? I am trying to Sort Part Usage back 2 years from current date.
See attachment.
I need to Pivot this data out to Year and Month.docx (63.7 KB)
Are you trying to make a BAQ column that contains just the year and month of a date?
Try
Make sure you use type Int
That’ll give you:
One last thing… I’d avoid using reserved words for variable or field names.
Thanks, Calvin. That worked but I still need to get it to Pivot. How do I tie the YearMonth to a Pivot list?
Pivot to this. I cant get it to fill the list in.
You want just 12 columns (for the months) regardless of the year?
Or a column for every Yr-Mo combo?
If its the first make 12 calc fields with the formula
Replacing the 1 with the month number for that column
The other columns will need to be in a group by
You’ll get:
If we can, I would like to have the YearMonth across the top And just the PartNum appear one time in the row to the left. I may have to do it in three queries, just thinking out loud. I was able to do it by the month but i was hoping for YearMonth.
Thanks,
Sorry, To answer your question. I would like Year-Month.