Forum Discussion

Ahmad_16's avatar
Ahmad_16
Frequent Visitor
3 years ago
Solved

How to add calculated column in table visualization based on row data on table visualization

  I need to know how to add a new calculated column that shows the value of sum of values divided by sum of vlaues for each row separately  This table is designed to filter the project phases as pe...
  • Ahmad_16's avatar
    3 years ago

    I searched on the Internet, 

    The solution is to create a new table using the Summary function, 

    to summarize and group the project phases, or any specific column or columns, 

    parent grouping, and parent-child groups in SSRS, 

    then add columns with a sum function to calculate the sum of values for each group, 

    then add a calculated column to apply functions on each row, 

     

    The result is as follows