Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to use aggr function in th following expression
sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)
What exactly is your requirement? Not really sure what to recommend unless we know what you are expecting??
aggr(sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount), yourdimension)
aggr will be performed by the sum using yourdimension
e.g. yourdimension is month
you'll get for each month the sum of Amount
if I am using three dimension.
Then Hw to write the expression ?
List out all of them:
Aggr(sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount), Dimension1, Dimension2, Dimension3)
But using this in a straight table with Dimension1, Dimension2, Dimension3 has no benefits, because its already doing the aggregation for you.