Hello,
How can I group set of data put into a table according to date. For example
<gs id="2099251c-e452-44d3-966d-e62d7100225a" ginger_software_uiphraseguid="6527a842-cd11-4e8a-9753-fbaa4cb84a5e" class="GINGER_SOFTWARE_mark">column</gs> A date
<gs id="a7283ebf-86d3-48b4-9a8a-d649af63a176" ginger_software_uiphraseguid="989f8770-ee77-4541-b6e0-4aba0ae4cb49" class="GINGER_SOFTWARE_mark">column</gs> B name
<gs id="eedeeaf9-99ff-48e2-9f80-273c07669465" ginger_software_uiphraseguid="96d6d4a3-44b0-4b2c-bc61-5de5644e8645" class="GINGER_SOFTWARE_mark">column</gs> C item
<gs id="91fb5b54-bf06-4cf3-af9d-01feb356db51" ginger_software_uiphraseguid="8f922cb5-c90e-48f4-a0c2-a2debc643c7e" class="GINGER_SOFTWARE_mark">column</gs> D quantity
<gs id="344d740e-79d0-4af8-8b67-3375ec8a5195" ginger_software_uiphraseguid="9fa43a2f-bca2-4a5e-8150-d55826e9a862" class="GINGER_SOFTWARE_mark">column</gs> E price
<gs id="a81023df-df2d-475c-8cd7-60d50491e20e" ginger_software_uiphraseguid="9e6fca34-77bb-475d-a586-34455566b098" class="GINGER_SOFTWARE_mark">column</gs> F total price
<gs id="2b4d1e18-284d-4985-9bbc-f3dd560eb645" ginger_software_uiphraseguid="2e0ccd46-6b52-48d0-b912-98d323330789" class="GINGER_SOFTWARE_mark">the</gs> idea is an employee may purchase different types of items with a limit of $750, and another set of employee with a limit of $ 1,500.
<gs id="ce37b362-f52e-477b-a664-d95e994b89e7" ginger_software_uiphraseguid="2b2aa907-cec5-4fd6-938d-0e359291fd80" class="GINGER_SOFTWARE_mark">Second condition</gs> is that purchase should fall between 2 transactions: 1st day to <gs id="ea488943-f742-47c8-99f1-dcea82716a90" ginger_software_uiphraseguid="2b2aa907-cec5-4fd6-938d-0e359291fd80" class="GINGER_SOFTWARE_mark">15th day</gs> of the month and 16th to end of the month
For example, employee A may order 5 types of items as long as it is within $750 from April 1 to 15, and may do another transaction, of how many types as long as it is within $750 from April 16 to 30
To summarize
Employee A date April 1 to 15 $500
Employee A date April 16 to 30 $750
Grouping <gs id="7ba69d41-5c43-4b64-86dd-e5f486fdfb1d" ginger_software_uiphraseguid="ba899c26-4d2c-42f3-a1db-4f39b8a9993a" class="GINGER_SOFTWARE_mark">of</gs> date and summarizing <gs id="c17e4eaa-bd41-405f-806b-81c890768c5c" ginger_software_uiphraseguid="ba899c26-4d2c-42f3-a1db-4f39b8a9993a" class="GINGER_SOFTWARE_mark">amount</gs> per cut off date is very important for me..
Thank you to those who will be able to help
How can I group set of data put into a table according to date. For example
<gs id="2099251c-e452-44d3-966d-e62d7100225a" ginger_software_uiphraseguid="6527a842-cd11-4e8a-9753-fbaa4cb84a5e" class="GINGER_SOFTWARE_mark">column</gs> A date
<gs id="a7283ebf-86d3-48b4-9a8a-d649af63a176" ginger_software_uiphraseguid="989f8770-ee77-4541-b6e0-4aba0ae4cb49" class="GINGER_SOFTWARE_mark">column</gs> B name
<gs id="eedeeaf9-99ff-48e2-9f80-273c07669465" ginger_software_uiphraseguid="96d6d4a3-44b0-4b2c-bc61-5de5644e8645" class="GINGER_SOFTWARE_mark">column</gs> C item
<gs id="91fb5b54-bf06-4cf3-af9d-01feb356db51" ginger_software_uiphraseguid="8f922cb5-c90e-48f4-a0c2-a2debc643c7e" class="GINGER_SOFTWARE_mark">column</gs> D quantity
<gs id="344d740e-79d0-4af8-8b67-3375ec8a5195" ginger_software_uiphraseguid="9fa43a2f-bca2-4a5e-8150-d55826e9a862" class="GINGER_SOFTWARE_mark">column</gs> E price
<gs id="a81023df-df2d-475c-8cd7-60d50491e20e" ginger_software_uiphraseguid="9e6fca34-77bb-475d-a586-34455566b098" class="GINGER_SOFTWARE_mark">column</gs> F total price
<gs id="2b4d1e18-284d-4985-9bbc-f3dd560eb645" ginger_software_uiphraseguid="2e0ccd46-6b52-48d0-b912-98d323330789" class="GINGER_SOFTWARE_mark">the</gs> idea is an employee may purchase different types of items with a limit of $750, and another set of employee with a limit of $ 1,500.
<gs id="ce37b362-f52e-477b-a664-d95e994b89e7" ginger_software_uiphraseguid="2b2aa907-cec5-4fd6-938d-0e359291fd80" class="GINGER_SOFTWARE_mark">Second condition</gs> is that purchase should fall between 2 transactions: 1st day to <gs id="ea488943-f742-47c8-99f1-dcea82716a90" ginger_software_uiphraseguid="2b2aa907-cec5-4fd6-938d-0e359291fd80" class="GINGER_SOFTWARE_mark">15th day</gs> of the month and 16th to end of the month
For example, employee A may order 5 types of items as long as it is within $750 from April 1 to 15, and may do another transaction, of how many types as long as it is within $750 from April 16 to 30
To summarize
Employee A date April 1 to 15 $500
Employee A date April 16 to 30 $750
Grouping <gs id="7ba69d41-5c43-4b64-86dd-e5f486fdfb1d" ginger_software_uiphraseguid="ba899c26-4d2c-42f3-a1db-4f39b8a9993a" class="GINGER_SOFTWARE_mark">of</gs> date and summarizing <gs id="c17e4eaa-bd41-405f-806b-81c890768c5c" ginger_software_uiphraseguid="ba899c26-4d2c-42f3-a1db-4f39b8a9993a" class="GINGER_SOFTWARE_mark">amount</gs> per cut off date is very important for me..
Thank you to those who will be able to help