Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Footer summary -- help pls

  1. #1

    Default Footer summary -- help pls

    Hi!
    Say I've got 3 fields.
    NAME TYPE QUANTITY
    Abc Pc 40
    Def Pc 23
    Ghi Pc 37
    Jkl Fd 5
    Mno Pc 7
    Qrs Pc 3
    Stu Pc 5


    Total rows = 7
    Total quantity = 120

    Getting total rows from the GROUP BY step is using the N-values. And sum for the quantity.
    Question is, how does one compute for Total Quantity for only Pc , which is 120 - 5 = 115.
    And, read from only the Fd type and print it as a new field (last column below)? so that the footer summary looks like:

    ...
    Stu Pc 5
    ----------------------
    7 120 115 5

    Don't worry about 7 and 120 I've figured them out.

    Any ideas would be appreciated. Thanks!

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    I would create a filter to direct a copy of PC rows to another stream.
    Then apply a Group By to this stream and once you have your result merge it back to the rest of your file.

    Mick

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.