Aggr function

[suvechha_b]

How to use aggr function in th following expression

sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

[sunny_talwar]

What exactly is your requirement? Not really sure what to recommend unless we know what you are expecting??

[Anonymous]

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

[suvechha_b]

if I am using three dimension.

Then Hw to write the expression ?

[sunny_talwar]

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.