Grouping Problem/Cross - Tab

[qlan]

Hi,

I am using CR10. I have a report that I group by Requester and below is my sample data that appears under my Requester Group:

RequesterName TRequest Tcancelled #OfOrders
2005
Robert Mack 10 2 8

2006
Robert Mack 7 2 5

However, on my Cross-Tab report it shows #OfOrders for 2005 as 14 and 2006 as 7 instead of 8 and 5 as what showed under my Requester Group:

2005 2006 Total
Robert Mack 10 7 17
2 2 4
14 7 21

How can I make it show 8 and 5 on the Cross-tab. Thanks so much!

 

[synapsevampire]

Perhaps you need a distinct count, at any rate if you showed example data, rather than some group aggregate, we'd have an idea of the underlying data.

Looks like basic row inflation to me.

-k

 

[qlan]

Mine was distinct count.