Quantity of lines

[michak80]

Hello, 

I have following  simple table (see below). In my report I need to count quantity of lines. So in Order 1 I have 2 lines and in Order 2 I have 5 lines but SKU 1 has 3 records. In my report my result should be 7 line. 

When I use "count" I recieve 9 lines. When I use cound count (distinct(...) I recieve 5.  

Could you please support me? My result should be 7 because in ORDER 1 I have 2 lines and for ORDER 2 I have 5 lines 

Order		Line
ORDER 1	SKU 1	1
ORDER 1	SKU 2	2
ORDER 2	SKU 1	1
ORDER 2	SKU 1	1
ORDER 2	SKU 1	1
ORDER 2	SKU 2	2
ORDER 2	SKU 3	3
ORDER 2	SKU 4	4
ORDER 2	SKU 5	5

[mfchmielowski]

My code is:

o:
load * inline [
Order,sku,	 	Line
ORDER 1,	SKU 1,	1
ORDER 1,	SKU 2,	2
ORDER 2,	SKU 1,	1
ORDER 2,	SKU 1,	1
ORDER 2,	SKU 1,	1
ORDER 2,	SKU 2,	2
ORDER 2,	SKU 3,	3
ORDER 2,	SKU 4,	4
ORDER 2,	SKU 5,	5
];

Ofter load the sample table with Order as dim and count(Order) as expresion
shows:
total: 9
order 1: 2
order 2: 7
For me it's correct 🙂

[MarcoWedel]

maybe

Count(Distinct Order&Sku)

?