To display one column in Pivot table with 2 entries

[Deepali_Prabhu]

In a pivot table, the column added before the values(Sale) has two entries : 'Yes' and ' No' as below:

But I need to display just the Yeses. Any suggestions are welcome.

2021				2022				2023
Sale		Sale %		Sale		Sale %		Sale		Sale %
Yes	No	Yes	No	Yes	No	Yes	No	Yes	No	Yes	No

[vinieme12]

use a Calculated Dimension

aggr(  only ({<Field = {'Yes'}>} Field ) , Field )

[Deepali_Prabhu]

Should this formula be put into "Show column if" segment of the field ?