Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    MShrini
    How to show the grand total with group by option ?
    Topic posted September 30, 2017 by MShriniGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports, Tip 
    241 Views, 10 Comments
    Title:
    How to show the grand total with group by option ?
    Summary:
    How to show the grand total with group by option ?
    Content:

    Can you please help us how to show the grand totals with group by option. I am trying to bring the report as below but i am not able to see option to bring the below bold values.  Please provide any hints to achieve the below requirement.

     

    Period Period wise Value Totals by Group by
    Jan-17 100 100
    Feb-17 200 300
    Mar-17 300 600
    Apr-17 400 1000
    May-17 500 1500
    Jun-17 600 2100
    Grand Totals 2100 5600

     

     

    Comment