I am using button object in pivot table to show total value or calculated value.
.in the below picture I have used button object to show total or 'calculated %' of all dimension value.
is it possible to display one row value at a time using button object?, means it should show only total revenue value first time,then direct expenses value second time without affecting others. means others should be in expand condition
In buttton object, search string criteria I have used all column value that i want to show in expression,but how to pass only one value at a time