crosstab data issue

[cognosun]

product    date             bdc cost
  1          10/1/2010        6     5
                     

I have this crosstab report where product, date are rows, bdc is column and cost is measure

But at database level under bdc field, the values are like 2,4 ...but in crosstab it's aggregating as 6.

i.e.

product    date       bdc cost
  1       10/1/2010     2     5
                                4

How shall i display the detail data under bdc, like above.

Many thanks,
Joys

[wyconian]

hi silly question but have you tried turning off the auto summarise?  Xtabs are supposed to aggregate though

[cognosun]

Yeah did that....but no use :-)

[jasmine0619]

Hello,

Crosstabs by Nature are supposed to aggregate. If you want it not to aggregate then I trick I find very usefull is that I always put a dimension record which makes it unique. You can always hide that column. If you have a time stamp then you can use that so 4 and 2 will appears on seperate rows.

If you want to display individual records, I think you should use a list and set the auto agrregate to false. Crosstabs and details just to gel together IMHO.

Good luck , let us know if it worked.

regards
Jasmine