Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2012-12-11T06:08:18Z by PratapReddygajjala
PratapReddygajjala
PratapReddygajjala
11 Posts
ACCEPTED ANSWER

Pinned topic Total revenue for Top 10 vs Others Comparison in Bar Chart

‏2012-12-05T08:36:43Z |
Hi Cognos Gurus,
i have following requirement.
we have three query items

Client Group, Client Sub Group,Revenue.

and one static prompt.

In Bar Chart,we need to compare Total Revenue for Top 10 Vs Total Revenue for OTher Clients.

Here the Top 10 should be based on Static Prompt.

when Client Group selected, total revenue for Top 10 Client Groups ,
when Cleint Sub group is selected , total revenue for Top 10 Client Sub Groups
has to be displayed in the chart.

appreciate your help!!

Thanks in advance....
GP
Updated on 2012-12-11T06:08:18Z at 2012-12-11T06:08:18Z by PratapReddygajjala
  • SystemAdmin
    SystemAdmin
    15496 Posts
    ACCEPTED ANSWER

    Re: Total revenue for Top 10 vs Others Comparison in Bar Chart

    ‏2012-12-05T12:34:11Z  in response to PratapReddygajjala
    Hi Pratap,
    This is very simple task.
    Steps to follow:
    Prompt Page:
    1) Create value prompt with 2 static choices(Client Group,Cleint Sub group)
    Create a new query for report
    1)Drag Revenue measure into new query
    2)Create New Data item for static choices and write code like
    case when ?yourprompt?='Client Group'
    then drag your Client Group data item
    else drag your Cleint Sub group data item
    end
    3) Create New Data Item for rank and write code like rank(Your Revenue Measure)
    4) Create Query Filter and write code like rank<=10
    5) Under Filter Properties Change Application to After Auto Aggregation
    Report Page
    1) Drag chart and select Bar Chart
    2) In X-Axis drag your client group and sub client group data item as you created in report query
    3) drag Revenue measure to default measures
    4) run the report.

    Attached file is sample report specification.

    Thanks,
    Suresh.
    • PratapReddygajjala
      PratapReddygajjala
      11 Posts
      ACCEPTED ANSWER

      Re: Total revenue for Top 10 vs Others Comparison in Bar Chart

      ‏2012-12-11T06:08:18Z  in response to SystemAdmin
      Thank you very much Suresh. with your approach i am able to compare top 10 vs others..

      Regards,
      pratap