Help me on aggr

[satishqlik]

!Hi,

My requirement is in the UI and backend

I have used in the front end Sum(distinct Actual) and also aggr(Sum(distinct Actual),[Profit Center])

But am not getting what exactly am looking for

PFB for your reference.

Any help will be appriciated.

[gowtham_patnaik]

Hi,

Try this expression:

Sum(aggr(Sum(distinct Actual),[Month-Yr],PC,[Profit Center],[Acct Name]))

[antoniotiman]

Hi,

May be

If(Dimensionality() > 0,Sum(DISTINCT Actual),Sum(Aggr(Sum(DISTINCT Actual),[Profit Center])))

Regards,

Antonio

[satishqlik]

What about in the backend???

I want to see in the data model.

[antoniotiman]

May be

Remove Join in second LOAD (t2 table) and expression :

Sum(Actual)