sum without 1 dimension

[Anonymous]

hi,

i have pivot table & i want in one expresion to calcult with one of the daimension .

how to write it ?

thanks'

yarin.

[sunny_talwar]

Not sure what you are trying to do. Can you elaborate a little and a sample would be very helpful.

Best,

S

[anbu1984]

For ex Dim are Dim1,Dim2

If you want to write expr without Dim2, then use Aggr(Sum(Field),Dim1)

[Anonymous]

i can't upload sample i'll .

in the pivot i have dimension with "cage_num" and "profile".

i mark the feild for this dimansion(cage_num) as "supress when vale is null",

when i do this i cant see the "kg" for the profile becuse he is realy don't have "cage_num".

is it posiblle in set analys to do sum(kg) with ignore the "cage_num" ?

[sunny_talwar · Accepted solution]

May be you are looking for something like this to ignore cage_num:

=Aggr(Sum(kg), profile)

HTH

Best,

S

[morganaaron]

You could just use a total over the dimension you don't want? E.g. Sum(Total <Dim1> Sales).