Incorrect Sum on Straight Table

[#1]

Hi Guys,

I think Straight Table is not right !

Background:

In my data model, OrderId repeats multiple times. and this is how the data model looks

What I am trying to do?

I want to see how many products are delivered and how many are shipped

I am using below expressions in straight table

For Total Delivered :  =num(Count(Distinct{$<StatusId={1}>}OrderId),'##,###,###')

For Total Shipped : =num(Count(Distinct{$<StatusId={2}>}OrderId),'##,###,###')

And I get this straight table

It looks right but shouldn't the total of delivered product be 4? instead of 2?

I have attached sample QVD with data.

Thanks

[#2]

lol sunny took screenshot and attempted to attach QVW so I thought i should mark you as correct answer compare to Kushal's short answer

but jokes apart.. and thank you both for replying my post.

[sunny_talwar]

Thanks for recognizing both our efforts

[Kushal_Chawda]

nahi bhai muje is helful k 50 points milne wale the isliye bola

[sunny_talwar]

je baat

[Kushal_Chawda]

[#7]

May you can earn more points by answering my another question?

How to manage Page Level when field does not exist?

[sunny_talwar]

I wish I had any experience in NPrinting to help you out

[#9]

no worries.. may you can answer this question then

Failover/secondary DB connection string