Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Help newby. Group columns and group rows.

  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

  2. #2
    Join Date
    May 2017
    Posts
    20

    Default

    Not to be TOO snarky, but you need to be able to write the query to return information within your SQL(Db tool) environment first, before you try to write something directly within PRD.
    You need the data coming in, properly formatted, to extract it out into your design layout.

    I would recommend

    select allMyStuff from blah
    where myDataQualifies
    grouped by year, month, hotel, stays
    ... ish

    Good luck!
    Iowabeef

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.