Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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