Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my dashboard, there is one Yearly View tab. I want the data of Yearly View will not affected by Date and Month selection.
It is working for Date. If I select any date, then value is not changing. But not working for Month.
I have used below expression:
=sum(aggr(sum({<DateTransaction_Key= ,CstFiscalPeriod= >}DISTINCT UnitsPlanned),CstFiscalPeriod))
=sum(aggr(sum({<DateTransaction_Key= ,CstFiscalPeriod = >}DISTINCT SalesPlanned),CstFiscalPeriod))
I am attaching my qvw.
Please check and help.
Add the set analysis also to the outer aggregation,
=sum({<DateTransaction_Key= ,CstFiscalPeriod= >}
aggr(
sum({<DateTransaction_Key= ,CstFiscalPeriod= >}DISTINCT UnitsPlanned)
,CstFiscalPeriod)
)
Add the set analysis also to the outer aggregation,
=sum({<DateTransaction_Key= ,CstFiscalPeriod= >}
aggr(
sum({<DateTransaction_Key= ,CstFiscalPeriod= >}DISTINCT UnitsPlanned)
,CstFiscalPeriod)
)
What is your Month Field here?
Could you please explain me sir..what is the function of outer aggregation?
Thanks,
Sarif
The Aggr() function is creating a virtual table with one or more dimensions and an expression.
You would need an (outer) aggregation function to aggregate the content of this virtual table just like you need an aggregation function in any expression: