aggregated value in pivot table total

[#1]

Hello

I have an aggregated value on a higher lever dimension that should repeated on a lower level dimension, the total should not be the sum of the  repeated value but rather the value itself.

the exemple is described bellow in the column expression 1 in the attached file

Thanks in advance for your help

[#2]

Try using Distinct...

[#3]

you mean  sum (distinct field)?

[#4]

Sorry distinct will not help you, attached app may help u ..

if

(RowNo()>=1,sum(Expression1),sum(TOTAL Expression1))

or

if

(RowNo()>=1,sum(Expression1),sum(DISTINCT Expression1))

[Clever_Anjos]

You can use a combination of

sum( TOTAL <Dim1,Dim2, <dim3>> value)

TOTAL = All records in table

<dim1> will return aggregate by dim1

<dim1,dim2> will return aggregate by dim1,dim2

[vikasmahajan]

Try

Aggr(distinct sum( TOTAL <Dim1,Dim2, <dim3>> value))

Vikas

[#7 · Accepted solution]

Actually I have found the answer, if you ever meet this sort of requirement you need to adjust the expression using dimensionality Function in my case

if(Dimensionality()=1

  or Dimensionality()=0,   sum([field]),    [field])

Thank you very much for your answers