Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: crosstab total pentaho reporting 5.4 or higher

  1. #1
    Join Date
    May 2017
    Posts
    1

    Unhappy crosstab total pentaho reporting 5.4 or higher

    Hi

    I have created cross tab using pentaho 5.4..its working fine..

    How to calculate row total and column total in cross tab.

    x y Total
    A 100 200 300
    B 50 100 150
    Total 150 300 450

    Please help me, I am tired :'(

  2. #2
    Join Date
    May 2016
    Posts
    282

    Default

    I haven't been able to get the row total (working with Pentaho 6.1) I've been able to get column totals and subtotals, but with a lot of work and it's quite tricky, getting my own labels and not the default ones on the totals' column header it's a pain, and I can't reproduce which properties I need to configure to get them right. I've kind of given up on crosstabs with Pentaho CE (no crosstab in Community Tools either).
    To get column totals and subtotals I have to define them during the crosstab definition, I can't edit the crosstab afterwards.
    Luck
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

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.