Show excluded and not excluded values

[chematos]

Hi,

I have one problem to solve and this is the case:

I have to show a table with 3 dimensions and 4 expressions, doesn´t matter the calculations, but the user selects one Stock Date that it´s not showing at the table, it´s only used as filter, so the table shows information about data that has relation with that Stock Date but I need to show also the excluded data that has no realtion with that Stock Date beacuse one expression returns the same value having relation or not with Stock Date and users wants to see all at the same time.

I was trying to use functions p() and e() but this only works as far as I know if I use the same dimension that I´m selecting and only with one simple expression, something like this:

Dimension in tha table: Stock Date

Actual Selection: Stock Date

expression: sum({ 1-$<[Stock Date] = p([Stock Date]) >} AnyValue)

In my table, [Stock Date] is not a dimension, I have other dimensions and I use set analysis in the expressions because I´m calculating values since 12 months before the [Stock Date] selected.

Any help will be apreciated.

Regards,

Chema

[whiteline]

If you select FullDate the Sum ({1-$}Value) returns everything right ?

And why do you select FullDate ? I thought you select Date (the value with nulls).

[sebastiandperei]

Disculpame, pero no comprendí bien el problema.

Podrías enviar una copia del qvw reducido?

[chematos]

The thing is that I can´t use aggr() function but I found a partial solution with the next expression:

sum(

          {1-$<Fecha_Stock -= {} ,

           Inicio_Mes={'>=$(=MonthStart(AddMonths(Fecha_Rotacion,-11)))<=$(=AddMonths(Fecha_Rotacion,0))'}

          ,[ROT.Mes Año]=,ROT.Mes=,ROT.Año=,Centro_Rotacion=,ROT.Fecha=>} [Cantidad_real]

)

/1000

This is not the right solution but its something, I'm not sure if the customer will be happy with that but I don´t know how to solve the problem without aggr