The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
How to display the aggregate Data - TIBCO Spotfire Community

How to display the aggregate Data

Last post Tue, Feb 19 2013 3:38 PM by rangman. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • Tue, Feb 19 2013 3:38 PM

    • rangman
    • Not Ranked
    • Joined on Tue, Feb 19 2013
    • Posts 1

    How to display the aggregate Data

    Hi all,

    I am new to Tibco Spotfire. If you could help me with the following would be great. Thanks in advance.

    Here's the data I imported into Tibco client.

    S_No     Sales_Person_Name       Sales_Dept       Qty_Sold         Revenue

     1           Tom                                 DEP_001           1000                $12000

     1           Bob                                 DEP_002           2000                $24000

     1           Jack                                DEP_003           500                 $6000

     1           Bill                                  DEP_001           3000                $36000

     1           Jim                                  DEP_002          100                 $1200

     

    I want to display a table having the following columns

     -----------------------------------------------------------------------

     Sales_Dept       Total_Revenue

     DEP_001            $48000

     DEP_002            $25200

     DEP_003            $6000

     -----------------------------------------------------------------------

    How to do this?

Page 1 of 1 (1 items)
┬ęCopyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center