button object in pivot table

[abc_18]

Hi,

How to show only one row at a time,while others field values remain unselected in pivot table.

I want to use button for this, so if I click on button object it should select one row value under first dimension, while others remain unselected..

[awhitfield]

Why not just use a list box with the dimension you require in it and select from that, one value at a time?

Andy

[abc_18]

Hi Andrew,

I can use list box,but it will give only row value that I will select from list box drop down.

in my application customer requirement is like if they click on one filed value in pivot table then total should display,(in this case total revenue is field value ) while others field values remain expanded.

if I use list box then it will display only one field value.

I have used pivot table properties to show total by selecting show partial sum check box, but in this application so many expressions are there , so its not displaying total value at last, so I am trying to do that by using Button object(select in field option.)