How to hide Crosstab Column which is used for aggregation but their values are not used

Hi ,


 


    I have developed report by using Crosstab.In that,one group Column as F is used in Summary field with column E.Without adding that F column,result of Summary field came as wrong..I just need F column for aggregation of E column.For that,I have added F Row...I dont need to show the datas of F column..Please help me to hide F Column.I have Attached the screenshot of report.Please do the needful.


 


Thanks in Advance.


 


By ,


Emy


Comments

  • Is F a dimension or a summary field? It looks like a row dimension in the image, but it's hard to tell.


    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • Hi Michael Williams,


     


              Thanks for your reply.It would really encourages us to go forward to getting out solution.


     


              F is a row dimension..F column is used only for summarize the E column.That row dimension F should be needed..There is no requirement to show the values of F column.Simply we used F row for summarizing E filed...Is there any javascript is available to hide this row?


     


    Thanks,


    Emy


  • hi emy,


        you need tell us more info about how column E is computed from column F.

  • EmyEmy
    edited March 2015

    Hi ,


     


      Thanks for your reply.


     


    Column E is a summary field..E is aggregate on by Group F/Column D..I don't want to show the values of 'F'..


     


    For eg,


     


    Header1   Header2  Header3  Column 1


     


    Value1      Value2      Value3     SummaryField(Value3/Column1)


     


    I need to hide Header3 & Value3...Group Value3 is used for summary field for aggregation...If i removed Value3 group,i cant able to aggregate summary field..


     


    I have attached sample iamge...In that,Inter Cont is a F field..Notification date is a Column filed...For Aggregation purpose ,F filed is required..


     


    Thanks in Advance.


     


    Thanks,


    Emy


  • The question I still have is why is there a grouping "Header/Value 3" if you don't even want to show it. If there are multiple value 3's for every value 2, why wouldn't you want to show the level 3 grouping. I guess I'd just need to see data. Either way, to get what you're wanting, you'd likely need to create a field in your data set that is row["field 2"] + "-" + row["field 3"] and make that a dimension in your cube that you'll use instead of your separate groups, then, just delete the data element for the new combined group and replace it with a data element that only shows the group 2 value or use script to show only what you're wanting. Hope this helps. I think I might have an example of this somewhere. I'll post it if I do. Otherwise, I can make one if you let me know your BIRT version.


    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • Hi ,


     


      Thanks for your reply.I'm using Eclipse BIRT Designer Version 4.4.0.v201405191524.


     


     


    Thanks,


    Emy


  • mwilliamsmwilliams BIRT Guru
    Take a look at this report. In the data set, I create a computed column that combines the two fields I want to group by to use in the data cube. In the report I have three crosstabs to show the differences.

    The first one is from the first data cube showing the groupings as is. The row dimension is the two field group and both fields are showing.

    The second one is also from the first data cube showing just the second grouping field, but still grouped by both. I achieved this by adding the second grouping field as an attribute to the dimension in the data cube (double click on the dimension field in the data cube editor and you'll see an area for adding attributes). In the crosstab, I just deleted the data element for the original group and added a new data element that used the expression for the attribute field instead of the actual group field.

    The third crosstab is a control crosstab that shows what the crosstab would look like if you only grouped by the second grouping field.

    Hope this helps.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com

  • Hi ,


     


        Thanks for your Valuable Reply..Now,i can able to solve that issue in my report...Thanks a lot :)


     


     


    Regards,


    Emy


  • mwilliamsmwilliams BIRT Guru
    You're welcome. Let us know whenever you have questions. :)

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: mwilliams.silanis@gmail.com


  • how to split a crosstab Columns into multiple crosstab tables???

    means. first 5 columns create one table next five columns create another table..


Sign In or Register to comment.