sir i have a case in which
Quantity fields can be +ve and -ve
some of values are -ve also. but pivot chart is adding -ve values also.
Pl check.
Data Sample
Public Class ProductSales
Public Property Product As String
Public Property DocDate As String
Public Property Quantity As Double
Public Property Amount As Double
Public Property SaleRate As Double
Public Shared Function GetSalesData(ByVal Dt As DataTable) As ProductSalesCollection
Dim listOfProductSales As ProductSalesCollection = New ProductSalesCollection()
Dim sales As ProductSales = New ProductSales()
sales.Quantity = 1
sales.Amount = 100
sales.SaleRate = 10
sales.DocDate = "13/01"
sales.Product = "ABC"
listOfProductSales.Add(sales)
sales = New ProductSales()
sales.Quantity = 2
sales.Amount = 200
sales.SaleRate = 10
sales.DocDate = "13/01"
sales.Product = "ABC"
listOfProductSales.Add(sales)
sales = New ProductSales()
sales.Quantity = -1
sales.Amount = -100
sales.SaleRate = -10
sales.DocDate = "13/01"
sales.Product = "ABC"
listOfProductSales.Add(sales)
Return listOfProductSales
End Function
Public Class ProductSalesCollection
Inherits List(Of ProductSales)
End Class
End Class