dimension restriction

[suvechha_b]

How to restrict the pivot table value.

I want to show product whose item_no =2.

I want to restrict through dimension.

[mishraamit2485]

You can use calculated dimension in dimension like, if(item_no='2',Yourresult,)

[Kushal_Chawda]

Create calculated dimension,

If( item_no=2, product). And check suppress NULL values option for this.

or

In your expression you can do something like below

sum({<item_no={2}>}Value)

[Anonymous]

The only way to do this would be to use set analysis - {Item_no = {2} - or a calculated dimension like Amit said.  Be sure to hide null values for each dimension when you use calculated dimensions.

[jonathandienst]

Something like:

     If(item_no = 2, product)

But for more accurate help, I suggest that you provide more information, and preferably your qvw application or a representative sample.

[maximiliano_vel]

Is this what you need?