Skip to Content
0
Former Member
Feb 08, 2012 at 10:28 AM

Cross tab Summary problem

20 Views

Hi Experts,

I have a requirement on Cross Tab Report here my scenario is as

Party name Unit1 Unit2 Total

Andy DocNum Qty1 Qty2 Qty1 Qty2

1 8 6 8 6

2 7 4 7 4

Total 8 6 7 4 15 10

My Requirement is like....

Party name Unit1 Unit2 Total

Andy DocNum Qty1 Qty2 Qty1 Qty2

1 8 6 =2 2

2 7 4=3 3

Total 2 3 5

I want difference of Summery value (Qty1-Qty2) in Same row and in total show only sum of difference value.

Thanks With Regards....