5 Replies Latest reply: Jul 19, 2011 6:16 AM by chowdhury RSS

    How to get Multiple data in one single row.

      Hi all,

      I have a chart using set analysis in the expressions to discard the date selection.

       

      Table1















      CalendarYear

      CalendarMonth

      Danish

      Dutch

      Finnish

      French

      German

      Italian

      Norwegian

      Spanish

      Swedish

      UK English

      Polish

      Russian

      GriefReports

       

       

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      195

      2010

      7

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      1

      2010

      7

      -

      -

      -

      9

      -

      -

      -

      -

      -

      -

      -

      -

      9

      2010

      7

      -

      -

      -

      -

      -

      20

      -

      -

      -

      -

      -

      -

      20

      2010

      7

      -

      -

      -

      -

      -

      -

      -

      21

      -

      -

      -

      -

      21

      2010

      7

      -

      -

      -

      -

      -

      -

      -

      -

      -

      54

      -

      -

      54

      2010

      7

      -

      -

      -

      -

      90

      -

      -

      -

      -

      -

      -

      -

      90

      Table 2















      What I   want is:






























      CalendarYear

      CalendarMonth

      Danish

      Dutch

      Finnish

      French

      German

      Italian

      Norwegian

      Spanish

      Swedish

      UK English

      Polish

      Russian

      GriefReports

       

       

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      -

      195

      2010

      7

      -

      -

      -

      9

      90

      20

      -

      21

      -

      54

      -

      -

      1

       

      I see all the data I'm expecting to see in the table1. The set analysis expressions work fine in the table. But it is showing multiple rows (Table1) for the month of July, I wanted to retrieve all data in one row. See table 2. To do this what sort of expression do I need? I think, i have to discard the grief report to get one single row information. Any idea you could share.............? Thanks.