how to get selected values using match function

[ravindraa]

Hi all,

   I have struck one place please give me any suggesion to come out from this.

my requierment is , i have one field that is DocId there are many DocId is there but i want only some DocID only for that i ahave used Match Fuction in Dimension to get requied DocId values, but along with requiered DocId values remaing values also coming as Null value , actuvaly i want remove the Null Values.

I can do the suppress null value check box but if i do that the sum of the sales is displaying as total value.

please give me any suggesion on this.

Please find the attached doc.

Thanks in advance.

[Gysbert_Wassenaar]

Try using DocID as dimension and as expression =sum({<DocID={110,111,112}>}Sales)

[ravindraa]

Hi Gysbert Wassenaar,

  Thanks for replying ,but is there any way to get selected values in dimension it selt only , becase for one dimension it is ok but i have more than 5 dimension's.

Please give me any suggession.

thanks in advacne.

[Gysbert_Wassenaar]

It hardly matters if you hardcode values in calculated dimensions or in expressions. If you want less work you make the selections first, then create a bookmark for those fixed selections. Then you can use the bookmark in the expression: sum( {BookMarkNameHere} Sales)

[ravindraa]

Hi Gysbert Wassenaar,

  thank you very much for replying could you please share how to get this using caliculated Dim,

thanks in  advance