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?