Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
!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.
Hi,
Try this expression:
Sum(aggr(Sum(distinct Actual),[Month-Yr],PC,[Profit Center],[Acct Name]))
Hi,
May be
If(Dimensionality() > 0,Sum(DISTINCT Actual),Sum(Aggr(Sum(DISTINCT Actual),[Profit Center])))
Regards,
Antonio
What about in the backend???
I want to see in the data model.
May be
Remove Join in second LOAD (t2 table) and expression :
Sum(Actual)