Case statement

[cognos05]

Hi All,

           
Please see the attached image for the screenshot.
   

Category1 – Data Item Calculation is (A+C)/ (A+B+C+D+E+F)
Category2 – Data Item Calculation is (B+D+E+F)/ (A+B+C+D+E+F)

I want the calculation of category 1 data item be applied for only QTY column under Prior YTD and YTD Columns as shown above in the screen shot.
I dont want them to be calculated for Full revenue and Qty columns nested under YTD Change and YTD Growth.

What should my expression for data item category 1 should have, should I have a case to compare the column if its qty under Prior YTD and YTD.

Thanks,
Nithya

[cognos05]

Hi,
The default content property when set to yes on a particular cell allows me to not write any data on the cell. But how do Iselect multiple cells and set default contents as yes. When I select multiple cells this property is not shown.

Thanks,
Nithya