Excluding Period selection is not working

[mhmmd_srf]

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.

[swuehl · Accepted solution]

Add the set analysis also to the outer aggregation,

=sum({<DateTransaction_Key= ,CstFiscalPeriod= >}

          aggr(

               sum({<DateTransaction_Key= ,CstFiscalPeriod= >}DISTINCT UnitsPlanned)

          ,CstFiscalPeriod)

)

[swuehl]

Set Analysis in the Aggr function

[vishsaggi]

What is your Month Field here?

[mhmmd_srf]

Could you please explain me sir..what is the function of outer aggregation?

Thanks,

Sarif

[swuehl]

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:

Dimensions and Measures

The Only Function