Simple trends report

[white_falcon02]

I am looking to create a simple trends report in report studio as a simplified proof of concept for a report we currently run in excel. The data is as follows in a database:

• Purchase date formatted mm/dd/yyyy
• cost with decimal places

I am looking to setup a studio report with 13 columns. Each of these columns would represent the previous 13 months and would have a format such as Oct 18, Sep 18, and so on.

For the row, the data would be a summary of purchase costs rounded off with no decimal.

I attempted to do this as a cross tab but with no luck. Can someone talk me through this first report?