Hi everyone,
I'm getting familiar with Report Studio, but had a quick question regarding crosstabs and calculations.
Basically, I have a cross tab with a relational DB setup as so:
[Total] [Subtotal 1] [Subtotal 2] [Subtotal 3] [Subtotal 4] [Subtotal 5]
Basically, I'd like to get a percentage of each Subtotal and display it next to the column. I can do this using Javascript, but I have a feeling there's an easier way. Any ideas?
I guess my question is, how do I setup the calculation to select the total of [Total] and divide by the content in the cell - I've seen a couple of different functions, but I'm really confused.
HI ,
I have that kind of report in crosstab,
In rows I have geographical information, in column the month choose from a prompt, age group (minor,major) and age by 5 year spread. The fact it's an amount of money , to get the the percentage we have to used : money/tuple(parent(currentMember(age_sp_5));money)
As I understand it, it will used the current total for the intersection divide by to total for all the group.. I know I'm not so clear but it's work ;-) . Look for " % of base" its almost the same.
Bye