Method Community

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?

Hey Mike,

You'll need to update the Format String as such:

-- Mortaza

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).

-- Mortaza

There are essentially 3 elements to this pivot grid, and I want the following:

• FullName (rows) - Bottom-Left for values AND the column heading
• Txn date (grouped by month) - Bottom-Middle for the column headings
• Subtotal (from the Invoice table) - Bottom-Middle for the data and the column headings.