Forum Discussion

balajisundaram's avatar
balajisundaram
Regular Visitor
1 year ago
Solved

In new visual calculation how do create a column to get percent of grand total

Count of retail outlet ID is a count customer ID (dimension)

  • Idrissshatila's avatar
    Idrissshatila
    1 year ago

    Hello balajisundaram ,

     

    use the following 

    Calculation = DIVIDE([Count of Retail Outlet ID], COLLAPSEALL([Count of Retail Outlet ID],ROWS))

     

    then you go to the formatting section and format it to show in percentage

     

     

    correct approach jeroenterheerdt ?

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    1 year ago

    Hello balajisundaram ,

     

    use the following 

    Calculation = DIVIDE([Count of Retail Outlet ID], COLLAPSEALL([Count of Retail Outlet ID],ROWS))

     

    then you go to the formatting section and format it to show in percentage

     

     

    correct approach jeroenterheerdt ?

  • Murtaza_Ghafoor's avatar
    Murtaza_Ghafoor
    Icon for Super User rankSuper User
    1 year ago

    Percent of grand total. Calculates the percentage of a value relative to all values, using the COLLAPSEALL function.