I am looking for an example on how to show the percentage difference from one column to the next in a crosstab.
I have a report that shows sales per month in dollars. For each month, I have added an additional column to the right that should show this value.
Hown can this be done? Everything points to some custom code which is not acceptable for my situation.
Example.
January February March
$100 0% $120 20%
3 Answers, 1 is accepted
Reports are data-driven. If you have two fields for each column, the third column can be an expression based on the other two fields. You can use also the Exec function to get data from a group or higher scope within the table item's scope.
The attached video can be previewed in IE browser. It illustrates the above suggestions.
I hope this helps.
Regards,
Stef
Telerik by Progress
Rank 1
Thank you for the post. However I don't believe I explained it properly.
I have attached a picture of the layout of my cross tab. you will see an empty cell that I would like to place my formula in.
My issue is that the column/row value I need is dynamic. The goal is to compare the total $ for Quarter 1 to Quarter 2 for a Year....and that year could be numerous years.
In crystal reports (sorry to reference that), there was an option to use the Previous value.
your example shows a static table and that is not what was asked. I need to do it in a crosstab as the years/qtrs are dynamic.
Please check the expression suggested by my colleague in this forum post. The idea is to sum only the values you need e.g.:
=Sum(IIf(Fields.subcol='one',Fields.val,0)) - Sum(IIf(Fields.subcol='two',Fields.val,0))The attached video can be previewed in Ie browser. The video illustrates the result of the above expression in our test.
Regards,
Stef
Telerik by Progress
Hello Erik,
Did you try the suggestions in this thread? If you did, what didn't work?
Can you send a runnable report, including sample data that demonstrates the requirement?