I need help to summarize my data (either sum or average) based on another column. For example with the data below, I would like to average rental rate and margin but sum revenue. Is it possible to do this? Everything is in one column so that I could drill down from multiple categories with each unique metrics. On that note is it possible to only format certain rows based on another column, for example if metric = margin, format in %?
Date Metric Amount January Revenue 100 February Revenue 200 January Rental Rate 50