Hi All
Can you please help for the
required solution:
need to have the SUM value Based on the Day and Sales person.
1.Salesman A selles some of the 20 varies of the fruits(for example)
2.Daily Sales of Salesmans will be downloaded from database.so it is not sure until we downloaded howmany types of fruits the salesman sold.
it could be 2 or 25 or 18.
3.Some day Salesman A sells 5 varieties of Fuits and other day 8 varities. it is not fixed
4.hence number of Rows for salesman A is bnot fixed.it will get change every day
5.I need a formula that can dynamically adjust every day for the salesman A range and sum the total value of the sales for the day.
6.I have nearly 2500 salesman and every salesman sales are like A.
7.need to total every salesman everyday with dynamically adjusted range.
please help.
Can you please help for the
required solution:
need to have the SUM value Based on the Day and Sales person.
1.Salesman A selles some of the 20 varies of the fruits(for example)
2.Daily Sales of Salesmans will be downloaded from database.so it is not sure until we downloaded howmany types of fruits the salesman sold.
it could be 2 or 25 or 18.
3.Some day Salesman A sells 5 varieties of Fuits and other day 8 varities. it is not fixed
4.hence number of Rows for salesman A is bnot fixed.it will get change every day
5.I need a formula that can dynamically adjust every day for the salesman A range and sum the total value of the sales for the day.
6.I have nearly 2500 salesman and every salesman sales are like A.
7.need to total every salesman everyday with dynamically adjusted range.
please help.
Attachments

46.8 KB Views: 9