Hi
How do I create a table showing total sales for each sales person where
one column showing results for selected date range i.e. 1st Aug 2015 – 5h Aug 2015
another column showing results for selected date range -1 day i.e. 1st Aug 2015 – 4th Aug 2015
And I want to be able to do this with 1 set of date parameters( start date and end date) without having another parameter for selecting yesterday's date.
Data Results Date Sales $ Rank Sales person Sales $ Yesterday Change John 01/08/15 $100,000 1 Carlton $1,200,000 $800,000 $400,000 John 02/08/15 $100,000 2 David $625,000 $500,000 $125,000 John 03/08/15 $100,000 3 John $500,000 $400,000 $100,000 John 04/08/15 $100,000 4 Bob $300,000 $300,000 $0 John 05/08/15 $100,000 Total $2,500,000 $2,000,000 $500,000 David 01/08/15 $125,000 David 02/08/15 $125,000 David 03/08/15 $125,000 David 04/08/15 $125,000 David 05/08/15 $125,000 Bob 01/08/15 $75,000 Bob 02/08/15 $75,000 Bob 03/08/15 $75,000 Bob 04/08/15 $75,000 Carlton 01/08/15 $200,000 Carlton 02/08/15 $200,000 Carlton 03/08/15 $200,000 Carlton 04/08/15 $200,000 Carlton 05/08/15 $200,000 Carlton 05/08/15 $200,000
Many thanks.
Mike
4 answers
Thank you so much Dana.
It worked. Yeahy!
Sorry to bug you, but would you also know how to count product names?
In the example below, I need to count number of product A sold and product B soled by each sales person.
Thanks heaps.
Mike
DateProduct SoldSales personDateName of Product SoldSales personCount of ACount of BJohn01/08/15ACarlton24John02/08/15ADavid41John03/08/15AJohn50John04/08/15ABob11John05/08/15AGrand Total126David01/08/15ADavid02/08/15ADavid03/08/15BDavid04/08/15ADavid05/08/15ABob01/08/15ABob04/08/15BCarlton01/08/15BCarlton02/08/15BCarlton03/08/15ACarlton04/08/15BCarlton05/08/15BCarlton05/08/15A
