Action Selection tool in a Pivot Table

Hi Everyone,

Just checking if its possible to select only one row at a time base on the “Transaction_Type”.
As currently clicking the value “108” will also include the “A2” row.


My current action fields currently showing only the Transaction_type and Date because both row “A1” and “A2” are calculated fields

And both ‘A1’ and ‘A2’ are inside the Field wells value

Any help will be appreciated. Many Thanks

I don’t believe this is possible because they are two separate rows in your field wells. If you could somehow join the two calculated fields into one, then you could add a filter to filter out that type based on the transaction type.