filter based in sum metrics

[Jsobrinho77]

Hi guys,

I have a calculated column in my table, and I need to create a filter with the same calculation.

my expression:

ColumnA
=if(sum({<FACT={'A'},Date={'$(=min({<client=>}Date))'}>}Value)=0,'Y','N'), this return Y or N and I need to create a filter to this expression, is it possible?

[sbaro_bd]

Hi @Jsobrinho77,

Filter works with dimension.

When we take a look on your expression, you try to use an aggregated mesure to create a dimension which by definition is non-aggregated. 

The best way to get a calculated dimension like a "dimension" is to create it from your script editor.

Regards.

[Jsobrinho77]

first of all, thank you for your answer..

this column is dynamic by date filter and client, I can't create into script editor, I need to create in the expression

[anat]

Create master dimension using same logic then use master dim as a filter