Skip to Content
0
Former Member
Mar 05, 2013 at 05:10 PM

Adding Key Figures under a structure in a Query

15 Views

Hi all,

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:

WEST

TOTAL

EAST

TOTAL

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:

WEST 500

EAST 600

TOTAL 1100

Cheers~

Attachments

Capture.JPG (16.6 kB)