tag:blogger.com,1999:blog-31405041.post115634965328346846..comments2023-10-24T05:42:21.905-07:00Comments on Data. Analytics. Code. @Everywhere.: Blogging on Pentaho, a FavoriteGretchen Moranhttp://www.blogger.com/profile/14898841044841630941noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-31405041.post-23043370845565460482013-03-30T23:33:17.162-07:002013-03-30T23:33:17.162-07:00I am trying to create Crosstab report using Hierar...I am trying to create Crosstab report using Hierarchy structure,have achieved most of the parts using Crosstab other group(Crosstab Page Group) Functionality,It is showing correct values at first time,but once I close the report i won't be open it again and it is showing "CASTING" error and the error because of Crosstab Other Group functionality.<br /><br /> Please find the below sample example for more details.<br /><br />Crosstab January February March<br />APAC <br />America 500 700 765<br />Australia 555 453 654<br />EUROPE <br />Germany 300 600 700<br />France 543 800 500<br />ASIA <br />India 500 300 200<br />China 700 800 900<br /><br />Is their any other way to achive this functionality in PRD or any Other way to eliminate CASTING error so that,reopen my report again without any problem?<br /><br />Any help on this will be much appreciated.<br /><br />Thanks,<br />Shail<br />shailhttps://www.blogger.com/profile/05049656449788620264noreply@blogger.com