data item

[scooter86]

Hi all,

ive a cross-tab with the measures on the rows and a dimension in the columns with 3 values.
what i need is to store just the 3rd value of one measure in a data item so i can put it in a chart?
how can i store this?
would i be able to do this using a simple case?
please help!!

Thanks in advance.

[MFGF]

Hi,

Is your package a relational or a dimensional one?  If it's a dimensional package, then a query calculation using a tuple() function would be the way to go.

For a relational package, either a case or if-then-else may suffice, or alternatively an extra query filtered on the third value and joined back to the main query.

Regards,

MF.