Forum Discussion
Appended queries optimization
Since my queries contain huge amount of data I try to create sample of the data in the excel.
I wonder, if merge function will be solution for me?
If you append with the names being the same this should be the result:
From here you can easily show total amount per customer or product.
Your are right tex628.
This is exactly what I have now. But I want to see 31+10+19=60 for 202 Customer.
If product id and customer id are the same I would like to sum the amount.
If you create a matrix and then use your columns like this:
Aren't you getting 60 for customer 202?In matrix view everything is ok. But, after appending I have 5 million rows. I want to merge these rows, sum amounts and get less row amount. Is it possible to group, or pivot, or merge my data on data level, not report level?