Exclude a measure from a pivot Looker

[Former Community Member]

Hi everyone,
Is it possible to create a pivot table on a time dimension (year-month) and exclude one of the measures used so that it is not repeated every month? Specifically I'm looking for a way to take the minimum date and maximum date for a given item. To do this I created two measures such as MIN(data) and MAX(data). But in this way it replicates the value for all the months, it only needs to be seen once.
Thank you all

[Emma_Docs]

Hello! I wasn't able to completely get what you're looking for, but you can pull specific values from pivoted rows/columns using table calculations like row() or pivoted_column(). So for example, I can highlight a value just once using:

if(pivot_column()=1, min(${orders.average_order_profit}), null)

Which produces: