Tabular Chart

[soha1902]

Hi All,

I have below data

ProductID	PrductName	Enable	Disable
16	ProdA	12/20/13	NULL
45	ProdK	10/18/13	NULL
49	ProdB	11/12/14	NULL
16	ProdA	NULL	12/05/14
45	ProdK	NULL	12/31/14
16	ProdA	11/20/14	NULL

Now I want following Output:

ProductID	PrductName	Enable	Disable	Price
16	ProdA	12/20/13	NULL	10
45	ProdK	10/18/13	NULL	10
49	ProdB	11/12/14	NULL	10
16	ProdA	NULL	12/05/14	0
45	ProdK	NULL	12/31/14	0
16	ProdA	11/20/14	NULL	10

Please help me to find the solution.

Thanks..

[MarcoWedel]

please post sample app and define the logic to calculate the Price column.

[maleksafa]

what is the logic behind it? how are you getting the price? it is not available in the first chart