I have a matrix report where columns will be generated with values in run time based on the grouping. I want to know if there is any way to get the value from the column in the run time.
Example
Total Col1 Col2 %
Row1 25 20 5 (Col1 * 100) / Total
Hope its clear. Please let me know if more information is required. I want to refer the columns total and col1 in run time to calculate%. Col1 and Col2 are generated based on column grouping.
swapna.anu
Contributor
2658 Points
745 Posts
Refer a dynamically generated column value
Jan 04, 2013 11:30 AM|LINK
Hi
I have a matrix report where columns will be generated with values in run time based on the grouping. I want to know if there is any way to get the value from the column in the run time.
Example
Hope its clear. Please let me know if more information is required. I want to refer the columns total and col1 in run time to calculate%. Col1 and Col2 are generated based on column grouping.
Thanks in advance.
swapna.anu
Contributor
2658 Points
745 Posts
Re: Refer a dynamically generated column value
Jan 04, 2013 04:01 PM|LINK
I got a work around using a hiden column and calculate based on the hidden column instead of using grouped column.
Hope this will help some one looking for similar solution.