Hi Forum,
There's a problem I'd like to solve.
I hope anyone can help me?
There's a query with 2 characteristics in rows.
For these characteristics are 3 formulas in columns using some selections.
On this setting we need 3 different conditions.
Step 1:
The first conditions should restrict the first characterics to the top x regarding formula 1.
Step 2:
The second condition should delete these characteristic of characteristic 2 less than a given value in formula 2.
Step 3:
The third condition sould restrict the remaining number of the characteristic 2 to the top x of fomula 3.
The sequence is fundamental.
Currently the top x of Step 3 seems to be calculated, but on this top x, the values of Step 2 where deleted. So, just the top x - y remains.
Has anyone an idea?
Thanks in advance for any idea.
Tobias