Hi,
I have two queries originating from same table.
which perform following (as shown in picture below)
1) filtering
these two queries bring specific filtered data, for example based on status "Processing" or "Done"
2) grouping
but the rest of similar data is grouped in each query.
3) Price in total , summed up
Note: Fields (Field1, Field2, Field3) are grouped and they are must have to be linked as per row. That's why they have relationship.
Problem:
as shown above, in combined query (where I want total of price, based on groups of Fields),
Each query has 4 rows (grouped data), but in combination is only three rows data, because the two are not common in these. But I want those as well.
How is possible? As shown in red rectangle.
Thanks
I have two queries originating from same table.
which perform following (as shown in picture below)
1) filtering
these two queries bring specific filtered data, for example based on status "Processing" or "Done"
2) grouping
but the rest of similar data is grouped in each query.
3) Price in total , summed up
Note: Fields (Field1, Field2, Field3) are grouped and they are must have to be linked as per row. That's why they have relationship.
Problem:
as shown above, in combined query (where I want total of price, based on groups of Fields),
Each query has 4 rows (grouped data), but in combination is only three rows data, because the two are not common in these. But I want those as well.
How is possible? As shown in red rectangle.
Thanks