1 Reply Latest reply on Oct 5, 2016 11:17 PM by Sreekanth Kasaraneni

    Table Calculation into Calculated Field

    Randy Adhitama Setiadi

      Hi All,

       

      I want to ask about how to convert table calculation info formula in calculated field.

       

      In this case I'm using Superstore database

      So i want to get the percent of total from Sub-Category, with table calculation I simply Go to Quick Table Calculation --> Percent of Total, and Compute Using --> Sub-Category.

       

      But I need to convert it into calculated field as basis for anoother calculation. When I go to the measure box, the formula is like :

      COUNTD([Customer Name]) / TOTAL(COUNTD([Customer Name]))

       

      This formula is simply compute percent of total using Table(Across), how can i convert the calculation but using Sub Catergory as the base

       

      Thanks

       

      Randy