Struggle with Set Analysis / Aggr in chart straight table output

[tomdabek]

I am struggling to get defined output in cells of a straight table when they are not totally related to the dimension.

In the table below i know i have to have some kind of formula with

sum([set analysis]

   aggr( 

          sum ([set analysis])

          , dimensions for the aggr function)))

But i conceptually cannot figure out how to make this work to get correct values in Customer Volume and Product Volume.

Customer	Project	Product	Volume	Customer Volume	Product Volume
Bill	A	Fence	4	23	6
Bill	A	Gate	9	23	9
Bill	A	Door	10	23	15
Steve	B	Door	5	5	15
Steve	C	Fence	2	2	6

[sunny_talwar · Accepted solution]

May be try these:

Customer Volume

Sum(TOTAL <Customer> Volume)

Product Volume

Sum(TOTAL <Product> Volume)

[Anonymous]

Hi

try this.

aggr(sum(Volume),Customer)

and

aggr(sum(Volume),Product)

FYI

set analysis will give you kind of filter :

if you want only customer : 'Bill' grouping by Product then...

aggr(sum( {<Customer={'Bill'}  >}Volume),Product)

But in your case , i do not think this helps ...