Aggr function

[suvechha_b]

How to write the following expression with aggr()

=sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units])

[gautik92]

aggr(sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units]),yourfield)

[jonathandienst]

Why? What are you trying to achieve? And how do you plan to use the expression?

[#4]

Hi suvechha

try to use

sum(aggr (sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units]),KEY ))

where the KEY is the dimension you want to make aggr function on.