I’m creating a performance dashboard but I’m struggling to create charts with:
- Conditional logic
- Sums/averages by category and total in the same view
I created this mock table and chart to show what I’m looking for. In this example, I’m looking to:
- Have the Actual Price bars in the chart only be an average of cells that are greater than $0
- Add a cluster of bars that show overall (i.e., including all categories) average of List Price and Actual Price
Is this possible? Any help making it happen? Thank you!