Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write the following expression with aggr()
=sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units])
aggr(sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units]),yourfield)
Why? What are you trying to achieve? And how do you plan to use the expression?
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.