I have built a Sales Query that reports on Customer with what region it belongs to such as EAST and WEST.
There are a few customers that are in EAST and WEST but in the results line it only shows the values of EAST & WEST separately.
If I simply add a TOTAL key figure it adds one line under all formulas:
NO VALUE TOTAL
I would like to do the following, If a customer has EAST and WEST then add the value together to show a total.
I would like something like this in the result line: