LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Pivot Table node

    Employee
    Posted 10-12-2016 18:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tris_717684

    Hi All!

    I'm new in the community and newbie with LAE.

    I need to produce an equivalent of a Pivot Table (in Excel) where there are two layers horizontally and the different months as headers. To illustrate:

    Employee Type Gender 2016-07-31 2016-08-31 2016-09-30
    Permanent Male 123 456 789
    Female 234 567 890

    I was able to produce a table (using the Pivot Table node) for the aggregate of the gender for permanent employees. I tried to include another field in the "GroupForRow", but ended with an error as it does not allow multiple fields.

    Thoughts on how to produce my requirements?

    Thanks heaps!

    All the best,

    tris