I have dataset in the format:
(https://i.postimg.cc/mchy3Tz6/data.jpg)
Can I do crosstab report and add row with calculate ?
(https://i.postimg.cc/fbS2VKjz/data-crosstab.jpg)
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'.
Thanks for reply. No I want add next row in crosstab but this row calculated before previous row
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?
Try this:
case [name]
when "nameC" then currentMeasure
when "nameB" then currentMeasure * -1
else 0
end
set the aggregation to total