Dimension without filters

[frank1982]

Hi,

I need to develop a table with a text dimension (called CD_INDICE_M) that doesn't have to keep into consideration the filter for this field.

This is my dashboard:

• Field's values of CD_INDICE_M

• Table

I try to write the Dimension using this syntax : =Only({1}CD_INDICE_M), but it doesn't work.

(Ora1,Ora2....Ora24 are expressions)

Someone could you help me?

Thank you in advance.

[sunny_talwar]

May be add {1} or {<CD_INDICE_M>} to all your expression's set analysis

[frank1982]

I'm sorry, but I don't understand, could you write the formula I should insert into the calculated Dimension?

Thanks

[sunny_talwar]

You mentioned Ora1... Ora2.. Ora.... are expression what exactly is the expression? Can you share the expression behind one of them?

[frank1982]

Yes, sure, this is the formula of the Expression Ora1:

=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}>}N_VALORE_1_MGP-N_VALORE_1_MI1)

vDataA and vDataDA are variables of input.

Anywhere, if I don't filter the field CD_INDICE_M my table is :

This is the result I would like to have.

[sunny_talwar · Accepted solution]

Try this

=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}, CD_INDICE_M>} N_VALORE_1_MGP-N_VALORE_1_MI1)

[frank1982]

Great!

It works!

Thank you very much Sunny!

You are the number one.