How to get Multiple data in one single row.

[#1]

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.

[swuehl]

Hi chowdhury,

it would be good if you could post an example qvw, that makes it a lot easier for us to understand and help.

If this is not feasible, then please post the expressions (I think there is a substantial difference between the languages and grief report, so if this is the case, please post a language example expression and the grief report expression).

Cheers,

Stefan

[michaelfreitas]

Hello

This helps?

Load

CalendarYear,

CalendarMonth

sum(Danish) as Danish,

.

.

.

from..

group by CalendarYear, CalendarMonth

[#4]

Hi,

i have attached qvd file. NB: for data, i have used Excel file. thanks

[swuehl]

Your second message today seems to be deleted from the thread, couldn't find the attachment.

[#6]

hi, i have figure it out. sum({$} Mod_Moderated) thanks anyway.