Simple trends report

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?

white_falcon02's picture
Joined: Apr 1 2017 - 11:59am
Last seen: 4 years 5 months ago

0 Answers:

No answers yet