Value Entry Report - Group the entries

Hi ,

I would like to combine item ledger entries qty, Cost posted to G/L of value entries data ( Normal entries + Adjusted entries) in a report.

currently, report's shows as two line like how it's in value entries, but I want to club both lines.

Pls, refer below.

I have tried below  - But it's not working

On Qty Column in report  - =sum(Fields!ItemLedgerEntryQuantity_ValueEntry.Value) 

on the Cost posted to G/L column  =sum(Fields!Cost_Posted_to_G_L_.Value) 

Thanks

Muthu 

Related