Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.