Cross Tab - is it possible ?

[lukasz921]

I have dataset in the format:

Can I do crosstab report and add row with calculate ?

[ThatKingslayer]

I am not entirely sure what you are asking as it looks like a word or two might be missing, however, if your question is whether or not it is possible to add Total or Summary lines to a crosstab on a report, the answer is 'Yes'.

[lukasz921]

Thanks for reply. No I want add next row in crosstab but this row calculated before previous row

[BigChris]

I'm also a little confused, and that might just be a lack of coffee on my part. In your example, are you only interested in calculating the last line on your crosstab? Do you, for example, want to calculate nameB - nameA as well? It looks like your dataset is sorted in quantity sequence...what happens / what do you want to calculate when the quantity is the same for two names?

[CognosPaul]

Try this:

Code Select Expand

case [name]
when "nameC" then currentMeasure 
when "nameB" then currentMeasure * -1
else 0
end


set the aggregation to total