Segregate Data based on Date along with required fields

[harinsh]

I am looking for some help in one formula to get the desired output...I have data table something like below...which includes Name, Date, Amt, Type and Place...
I have only Type1, Type2 and South, North...these will not change.

Name	Date	Amt	Type	Place
AA	20-Feb-19	$ 2,082	Type1	South
BB	20-Feb-19	$ 2,110	Type1	North
CC	20-Feb-19	$ 1,723	Type1	North
DD	21-Feb-19	$ 4,528	Type1	North
EE	21-Feb-19	$ 4,554	Type1	North
FF	21-Feb-19	$ 2,943	Type1	South
GG	21-Feb-19	$ 4,638	Type1	South
HH	22-Feb-19	$ 4,212	Type1	South
II	22-Feb-19	$ 2,308	Type1	South
JJ	22-Feb-19	$ 2,337	Type1	South
KK	22-Feb-19	$ 4,881	Type1	North
LL	23-Feb-19	$ 3,663	Type2	North
MM	23-Feb-19	$ 1,004	Type2	North
NN	23-Feb-19	$ 4,559	Type2	South
OO	24-Feb-19	$ 3,779	Type2	South
PP	24-Feb-19	$ 1,513	Type2	South
QQ	24-Feb-19	$ 3,585	Type2	South

<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>

I need to segregate based on "Date" field...each date should give one set of table..for example given below for 20th Feb...it should segregate whatever available for both North and south data sets separately

20-Feb-19
Place	Date	Name	Type1 -Amt	Typ2 - Amt	Total
South	20-Feb-19	AA	$ 2,082	0	2082
Place	Date	Name	Type1 -Amt	Typ2 - Amt	Total
North	20-Feb-19	BB	$ 2,110	0	2110
North	20-Feb-19	CC	$ 1,723	0	1723

<colgroup><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

 

[jondavis1987]

Is it a pivot table? If so you should just be able to move date into a filter field and have it separate that way. If you're not using a pivot table then i would suggest going that route.

 

[harinsh]

Is it a pivot table? If so you should just be able to move date into a filter field and have it separate that way. If you're not using a pivot table then i would suggest going that route.

No, its not pivot table and normal data set...I forgot to add another criterion called "Open" and "Close" here you have the updated data set and out table also should give like one data for "Open" and one for "Close"

Data Set
Name	Date	Amt	Type	Place	Status
AA	20-Feb-19	$ 2,082	Type1	South	Close
BB	20-Feb-19	$ 2,110	Type1	North	Open
CC	20-Feb-19	$ 1,723	Type1	North	Open
DD	21-Feb-19	$ 4,528	Type1	North	Close
EE	21-Feb-19	$ 4,554	Type1	North	Open
FF	21-Feb-19	$ 2,943	Type1	South	Open
GG	21-Feb-19	$ 4,638	Type1	South	Open
HH	22-Feb-19	$ 4,212	Type1	South	Open
II	22-Feb-19	$ 2,308	Type1	South	Close
JJ	22-Feb-19	$ 2,337	Type1	South	Close
KK	22-Feb-19	$ 4,881	Type1	North	Close
LL	23-Feb-19	$ 3,663	Type2	North	Open
MM	23-Feb-19	$ 1,004	Type2	North	Open
NN	23-Feb-19	$ 4,559	Type2	South	Open
OO	24-Feb-19	$ 3,779	Type2	South	Close
PP	24-Feb-19	$ 1,513	Type2	South	Close
QQ	24-Feb-19	$ 3,585	Type2	South	Close
Output require
20-Feb-19	Closed
Place	Date	Name	Type1 -Amt	Typ2 - Amt	Total
South	20-Feb-19	AA	$ 2,082	0	2082
20-Feb-19	Open
Place	Date	Name	Type1 -Amt	Typ2 - Amt	Total
North	20-Feb-19	BB	$ 2,110	0	2110
North	20-Feb-19	CC	$ 1,723	0	1723

<colgroup><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

 

[harinsh]

Hi jondavis1987,

I hope answered your question ...

 

[jondavis1987]

Honestly the only way I know how to do that is to turn it into a pivot table. Move those headings into the filter. Then you can have it all filter the way that you want. I'm not sure how to go about separating them with a formula.

 

[harinsh]

Honestly the only way I know how to do that is to turn it into a pivot table. Move those headings into the filter. Then you can have it all filter the way that you want. I'm not sure how to go about separating them with a formula.

No Pivot, won't work for my output ...I am sure using index/aggregate can be done...