How to Pass other column values by clicking on the selected column/row in the pivot.
-for Ex. I have take country as a row and Month as a column. Now I want to pass the value of the product line of that country [ hidden value should be unique for clicked column] on click of country, there is a list named 'Value' in row/column setting window. In the value list of available columns displayed and you can select the product line here. save it and now when we click on the country name in the pivot at backside data sent will be the name of product line of that country.