I created a cross tab report in the report studio.
I need the create a calculated column ( Currrent Year – Last Year).
Item Group 2008 2009 2010 Cu.Year-Last Year
Item Group1 10 16 75 59
Item Group2 20 26 12 -4
In the drill down I expect the following output
1. When I drill down "item group1" to items level, it automatically calculate the current year- last year
2. When I drill down year ( 2010) to month, the output is also change to same, current year- last year.
How I can achieve these result?
Mathew
The result for 1 should happen automatically. What problems are you getting?
MF.
In query, in which insertable object i have to use to calculate the difference between 2 yeas.
If i use "Data Item", i can not apply the conditional style .
How to make the conditional style , if i use "data item" to calculate the difference between 2 years. now all the values coming in the "Missing Values" range of Conditional style .
hi,
in query, i added a data item and create calculation to find the difference between 2 members. But this data item comes as "string" and i can not apply style condition, because it is string.
How to convert the data item string to number.
Mathew