Sales vs Budget data

[vireshkolagimat]

Hi All,

I am trying to show the sales vs Budget data but i am not getting the expected result.

Sales is captured on daily basis and budget is for entire month. I made the changes to the budget data to adjust day wise.

when i look the data by agency and salesman level, it looks good. But when i bring the Brand name, the data is not coming properly.

Budget is updated by agency and by brand.

Agency	Salesman	Brand	Net Sales	Budget Value
ABC	1234		0.000	5,000.000
ABC	1234	X	2,376.125	0.000
ABC	1234	Y	299.715	0.000

Kindly help me to fix the issue.

Regards,

Viresh

[YoussefBelloum]

Hi,

on this table:

Agency	Salesman	Brand	Net Sales	Budget Value
ABC	1234		0.000	5,000.000
ABC	1234	X	2,376.125	0.000
ABC	1234	Y	299.715	0.000

what is your exptected output on the Budget ??

[vireshkolagimat]

Hi, The output should come like below.

Agency	Salesman	Brand	Net Sales	Budget Value
ABC	1234	X	2,376.13	5000
ABC	1234	Y	299.715	5000

Thank you.

[YoussefBelloum]

Try to attach some rows from your table