Match Function Error

[#1]

Hi Friends,

I am using the code Mathc(xxx,01,02,03)  to get values related to only 01, 02 and 03 respective.

But its alos giving values related to 00 also.

Should I add anything to remove 00 from filters.

Thanks

Pavan

[#2]

Thanks Wedel

It works  But one more problem. I added another field 'Agent Number' which is a primary key.

I am geeting all the values of primary key into pivot table.

I want 'Agent Number' into piovt table only if XXX is equal to 01 and 02.

Thanks

Pavan

[jyothish8807]

Hi Pavan,

In dimension write:

Only({<XXXX={01,02}>}Agent Number)

Regards

KC

[#4]

The Problem is Its not displaying 00 but displaying balnks instead.

[jyothish8807]

Then do this:

If(match(xxxx,01,02)>0,XXXX,'00')

Regards

KC

[#6]

Hi Wedel/Jyothish

Thanks

My problem solved.

[#7]

Hi Wedel,

I used If(match(xxx,01,02),xxx). Now all the values which are not matching are gouped into one and giving me total at the last row as blank total.

I dont want any of the non-matching values.

Thanks