Action Selection tool in a Pivot Table

Question & Answer
, , , ,
1

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.

image

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

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

Any help will be appreciated. Many Thanks

2

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.