Aggregating only one node item in the cross tab

[JO]

Dear All,

I have requirement in the cross tab. I have 3 diff columns Buy, Actual and Index which is showed against the market day wise.

Index =Actual/Buy

The way it is shown is
           | Monday  |Tuesday |
Market  |  Buy      |       --   |Total Buy
           |   Actual  |      --   |Total Actual
           |  Index    |      --   |Total Index

The Buy , actual and Index are getting displayed properly.Where as when it comes to total, Total buy and total actual are callculated properly but total index should be total actual/total buy, where as it is getting aggregated index. Can any one help me how to achieve this.

In brief, I want to display total buy and total actual correponding to buy and actual column and total index should be total(actual)/total(buy) not aggreated index.

Thanks
Jo

[blom0344]

Did you try to define the overall index as:

total[actual]/total[buy] with the aggregate type set to calculated and the solve order 1 higher than the other measures?

[JO]

Hi blom,

Could you please explain briefly.

The way it is displayed in the cross tab is the index values for an index row and the same index getting aggregated in total index column. The index column has as Define content function which is set to No. I tried setting to Yes and override it with calculated column, But it is not showing up.

Thanks
Jo

[blom0344]

In the 'Report Studio 8 Version 8.2 User Guide'  there is a chapter on 'Multiple Calculations in Crosstabs'
The example that is used looks pretty much like your case.
The user guide should be among the documentation of your Cognos CD's or can be downloaded from the KB

[JO]

Thanks blom.

I am able to achieve it.

Thanks once again for the solution
Jo