Straight table Hyperlinks to be Display Values in Pivot table

[Anonymous]

case 1: hyperlink to each value for  the column  "Variance". Such that after clicking on that hyperlink value the pivot table should pop up.

case 2:Pivot table here should show only non matching values.

A	B	Variance
13	2	11
11	11	0
2	4	-2
3	2	0

Here Variance column values should Act like a Hyperlink(11,0,-2,0).on clicking should displat pivot table with only matching columns

[Gysbert_Wassenaar]

That is not possible. If you click on a value of an expression in a chart then all the dimension values of the same row are selected. If you click on the value 11 then value 13 is selected in field A and value 2 is selected in field B. No pivot table will pop up. You can try creating a conditional display expression for the pivot table to show/hide it depending on the number of selected values in field A and/or B. You can use the getpossiblecount function for this purpose.

[Anonymous]

Thanks Gysbert for your Quick Response.i have 6 Dimensions & 3-Expressions in st.table if we select variance suppose 11 it should display values in some other object with non matching say(1,3) rows remaining matching 2,4 rows not to be diplayed.Any chance of possiblities to achieve this.