SQL Server Performance Forum – Threads Archive
How Calc percent in matrix column?I have a SQL report that contain matrix. One of it’s Column Group contain SubTotal column . If I get on the Dynamic Column Group results 2 columns that Data values are 5 and 3, I get in the SubTotal column only 8 (I add the operation SUM in the expresion of the Column Group.
Now I want to add column the it’s value is the precent of 5 from 8. (5 is the value in the first column and 8 is the SubTotal) How to do this???
What should be the expresion? In fact I nees to write expresion that operate (Column group value/Subtotal) How can I do it???