RE:Seperate column

[Chanty4u]

Hi all ,

Sunny T

I have data like Paid and Received .  tables with the column names  for the month of April ... and i have same paid and recvd for every month .

PaidTable:

Date  ProductName  PaidAmount  

ReceivedTable:

Date  Productname  RecvdAmount

so now my requirement is:

1)  in paid table  having same product transaction is multiple times so i need to sum of the products amount in  Paid and Received tables

2) and i need create the column   PaidAmount-ReprievedAmount    as summary

and if     PaidAmount-RecievedAmount    is Negative  display as  Payable 

if it is positive   display as receivable

Thanks in advance

[sunny_talwar]

What is the expected output in terms of numbers that you would want to see?

[Chanty4u]

Hi sunny,

all yellow and green [Means having multiple transactions with same productname]  product amount should be summed  and disply in seperate column as  Total amount of each product   for both the tables.   hope this is clear.

be screen shots

[HirisH_V7]

Hi Suresh,

You want to see above output or their you mentioned as 'disply in seperate column as  Total amount of each product' Means another row or what!!

-Hirish

[Chanty4u]

yes hirish.  other row   i need.

[HirisH_V7]

Can You Post in a excel sheet what your'e looking for.

[HirisH_V7]

Hi Suresh,

Morning!

is this what your'e looking for,

Else, Let me know your requirement with further details.

-hirish

[Chanty4u]

yes hirish,  We are done that but need to check with my Manager .

can you share your Sample Qvw.

[HirisH_V7 · Accepted solution]

Okay.

PFA,

Hirish

[Chanty4u]

Thank you hirish