Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Pavan,
In dimension write:
Only({<XXXX={01,02}>}Agent Number)
Regards
KC
The Problem is Its not displaying 00 but displaying balnks instead.
Then do this:
If(match(xxxx,01,02)>0,XXXX,'00')
Regards
KC
Hi Wedel/Jyothish
Thanks
My problem solved.
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