2 Replies Latest reply on Aug 4, 2016 6:27 AM by Natali Araujo

    Fixed Denominator

    Natali Araujo

      Hello,

       

      I am trying to create a Price Index Calculation. My database has the follwing product structure:

       

      Category > Holding > Brand > SKU

       

      My question is: Is the SKU price above or below category average? To answer that, I have created:

           - Price/SKU --> Sum (value sales) /Sum (volume sales)     This returns me a AGREG Calculation

           - Price/Category --> {Fixed [Category]: Sum (value sales) / Sum (volume sales)}

       

      Price index should be "Price/SKU / Price Category" but Tableau doesn't allow me to mix an Aggregated calculation with a Non Aggregated one.

       

      Does anyone know how to solve this?

       

      Thanks in advance.