on 01-31-2005 10:35 PM
Is is possible to use a condition in a query that has a structure in the rows? If so, please explain.
Hi Diane,
A condition in a query works with a key figures structure in rows, with a characteristics structure in rows, even with two structures in rows. Why don't you just try.
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eugene,
I should elaborate. Yes, I have tried it and it does work if I have 1 selection within the structure within the rows. I have multiple rows with the same material that is grouped within the selections by a transaction type. When I have more than 1 selection, any material that meets the conditions at the first selection level is repeated in every selection although the criteria is not met. I feel this defeats the purpose of using a condition. I would like it to consider each record independently. If you do not receive this type of results, perhaps you are doing something different than me. Please advise.
Thanks,
Diane
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.