I have a pivot grid like the one below (below is the Method sample).
The TxnDate field is grouped by months. How do I get the months to display in MMM format?
You'll need to update the Format String as such:
Thank you I was entering that in the "Cell Format" field instead. That's why it didn't work.
How about centering the Column Header (label) and the column values? Any options for that?
You will need to adjust with left side Appearence options to achieve the formatting you would like: (ie. text alilgnment).
There are essentially 3 elements to this pivot grid, and I want the following: