I have a requirement like this
In list report I have columns
Product type
customer
Pch Development (this is the caluclulation if (product_type='PCH development) then amt else(0)
Net development (this is also the same wany)
;
:
:
like this I have ariund 20 amouts
Requirement is I need to burst the report on product_type If I am bursting my list report is showing 1 column value depends on the product name and remaining all Zeros but my client want to see all the values
Any sugesstions pls
Please Help me
Are you using [Amt] in your report?
Thanks for the reply Prit. Yes I am using amt as
If(product _type='XYZ) then(amount) else(0)
Like this I am using not direct amount column