Search code examples
sqlreporting-servicesssisbids

Complex SSRS Report to calculate a field

I am stuck with this report pattern can anyone help me out how to deal with this situation? Here is what want to accomplish on SSRS

I have table Units distribution High 10 (10/30) -33% low 20 (20/30) -66% total 30

how can we use the total value of high, low rows to calculate distribution?

Sample Pic with formulas table and Data table

and here I want to achieve data table on right on the picture, so I want to implement the formulas table pattern on Data table using SSRS, I have already pulled the data.

Thank you

Solution

  • create a dataset that will return those rows as columns.. then display the table vertically (columns to rows) since the structure is fixed.