Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')))))))))