Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Help newby. Group columns and group rows.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question Help newby. Group columns and group rows.

    Hi to everyone. I'm trying to create a report using a query that return something like that:

    Year|Month|Hote|Stays
    --------------------------
    2016 | 1 |Hotel1|2534
    2016 | 2 |Hotel1|2111
    2016 | 2 |Hotel2|2523
    2016 | 2 |Hotel3|2231
    2016 | 3 |Hotel1|2234
    2016 | 3 |Hotel2|2123

    And I want to create a report like that:

    2016
    MONTH |Hotel1|Hotel2|Hotel3
    ---------------------------------------------
    Month 1 |2534 |____ |____ |
    Month 2 |2111 |2523 |2231 |
    Month 3 |2234 |2123
    Month 4 |etc......

    I'm not figure out how to create the column a row groups to create it.

    Can somebody point me to the right direction?

    Thanks in advance.
    Last edited by miquelangeld; 08-25-2017 at 06:58 AM. Reason: error in formating table

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.