Thanks Shin! This is a great start I will play around with this format and see where it takes me. One question I have though is when I pull over my pivot field values that stay as dimension and don't turn into the measures that are in the images you provided. Am I missing a step?
right click that pill and select exact date. If the field is not recognized as date, you also need to change the filed type to date.