Just make your field discrete and both your problems will be gone. You do that by right-clicking on the MDY(LoanFundingDate) pill on the rows shelf, and selecting the option "Discrete" (the third bottom-up).
Hope this helps...
I don't understand. The field is already Discrete in the Dimensions box. And I don't get an option to change it when I right-click on the rows shelf. I'm working with Version 7.0.0.
Right click on the Loan Funding Date field on the rows shelf and select Exact Date. Right click again and select Discrete. Right click, yet again and select Format... Under the Format box, choose the Header tab and under Default change the date to the desired output.
Hope this helps!
Now that you told me, it's obvious!