Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
use a Calculated Dimension
aggr( only ({<Field = {'Yes'}>} Field ) , Field )
Should this formula be put into "Show column if" segment of the field ?