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

    Fixed Denominator

    Natali Araujo



      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.