group by records in application not in script

[#1]

Hi,

I have below sample records coming from SQL , I want to group those records and show sum of amount in report

Is there any function I can use to achieve at application or report level , I do not want to apply any change at script level

I

Item	Region	Amount
A	Austin	20
A	Austin	30
B	Dallas	40
B	Dallas	20

Expected Results:

Item	Region	Amount
A	Austin	50
B	Dallas	60

Message was edited by: Vibhu Sharma

[sunny_talwar]

May be create a straight table

Dimensions

Header 1

Header 2

Expression

Sum([Header 3])

[#3]

will it include group by automatically for Item and Region

[Anonymous]

Yes It will apply grouping for both Item and then Region

[swuehl]

You are touching the very core of QlikView (and similar tools in general), understanding

Dimensions and Measures

[sunny_talwar]

I don't see a reason why it won't