Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try using Distinct...
you mean sum (distinct field)?
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))
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
Try
Aggr(distinct sum( TOTAL <Dim1,Dim2, <dim3>> value))
Vikas
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