5 Replies Latest reply: Mar 1, 2012 12:19 AM by Celambarasan Adhimulam RSS

    Aggregating rows for display

      I have a single table in load statement. It has some measures and dimension (attributes).

      Country

      Region

      State

      State ID

      Sales

       

      I want to display a report with Country & Sales Income only. I do that but when i see the report on IE it repeats the country value for all stateID's. I just want to see one row per country with sum(Sales). It is a simple group by in SQL but I don't want to do it on LOAD statement as I want to use the state info in another tab.