3 Replies Latest reply on Nov 26, 2018 8:31 PM by Aaron Sheldon

    Mixing Aggregate and Non Aggregate with Dynamic Measures and DImensions

    David Matthews

      Thanks In Advance for any help.

       

      I've created a sample workbook here with dummy data using Superstore to demonstrate my problem. I have a treemap where users can choose dynamic measures and dimensions. So category will be represented by Color and measure will be represented by the size of the box. The problem I am having is most of the measures are simple measures and not calculations. When I try to add a calculation I get the cannot mix aggregate and non aggregate error. Any idea how to get around this in my scenario here using the case statement for Choose Primary Measure? I am trying to add Sales/Quanty as Sales Per to the measure options in the drop down.