Calculated Column and Filter Issue

[hs219]

Hi!

I have a question about a issue in a calculated column and filter.

I've created a formula that return the values correctly.

When I put this same formula in a calculated column in the pivot, it returns the correct values.

But when I have a filter with this same calculation and then filter the data, the pivot returns me the wrong values.

Can you help, please?

Thanks.

The formula used for calculated column in pivot and filter is this one:

=if(not match([FIELD 1],'STRING 1','STRING 2') and [FIELD 2] = '*', 'RESULT 1',

if(WildMatch([FIELD 1],'STRING 1','STRING 2') and not match([FIELD 2],'STRING 4','STRING 3','STRING 5'),'RESULT 1',

if(WildMatch([FIELD 1],'STRING 1') and WildMatch([FIELD 2],'STRING 6'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 1') and WildMatch([FIELD 2],'STRING 5'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 2') and WildMatch([FIELD 2],'STRING 6'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 2') and WildMatch([FIELD 2],'STRING 5'),'RESULT 2',

if(IsNull([FIELD 2])=1,'RESULT 1',

if(len([FIELD 2])=0, 'RESULT 1',
if([FIELD 1]='*' and [FIELD 2] ='*', 'RESULT 1','RESULT 1')))))))))

[dplr-rn]

i would suggest doing this calculation in the load script and create a column. Use that column in your table and filter

[hs219]

Is not possible to do in that way because the columns are from different tables and isn't possible to join them on script.