Problem Whit Grouping QV11

[ester_pr]

Hi All,

I Have a problem whit Grouping Set Analysis

for example :

sum

({[Group 1]<Region = $::Region, [Sales Rep] = $::[Sales Rep]>} Sales)

If I am looking at Part Dimension and ther is a Part that have no Region the values will show 0

How will i make the object consider Region selection without Deletion data?

[swuehl]

ester_pr,

not sure if I understand your issue, is it a problem with grouping in a chart or with alternate states / set expression?

I think it would help if you could post a small sample qvw file here or describe your data model a bit more detailed.

Regards,

Stefan

[ester_pr]

Stefan thanks,

As you can see ,

there are 2 columns,

1 column is a simple sum

the other column  a sum that allows reference to list box of code filed

when ever code is null to snif as in kvj the value becomes 0

Regards,

Ester

[ester_pr]

Stefan thanks,

As you can see ,

there are 2 columns,

1 column is a simple sum

the other column  a sum that allows reference to list box of code filed

when ever code is null to snif as in kvj the value becomes 0

Regards,

Ester