Creating complex Pivot Tables

Abhii2658

I have a rather unique requirement here. My data  has 70,000 records and based on the below filters i need to populate the count of the final field and display the entire row for the result. The table looks like this 

The first 6 lines are the filters need to get the subset of the 70,000 records and on the basis of that, 4 fields are grouped resulting in the final count field which then displays the entire row. of the total number of fields 

Field A - Filter Blank
Field B - Filter Blank
Field C - Filter 0
Field D - Filter yes
Field E- Filter All
Field F- Filter Yes
Group by Location	Group by Field A	Group by Field B	Group by Field C	Count of  Field D
Location 1	AB10	123	ABC	10	This should should show the entire record that consists of 50 fields
	AB10	123	ABC	10
	AB11	123	ABC	10
	AB12	123	ABC	10
	AB13	123	ABC	10
	AB14	123	ABC	10
	AB14	123	ABC	10
Location 2	CD10	123	ABC	10
	CD11	123	ABC	10
	CD12	123	ABC	10
	CD13	123	ABC	10
	CD14	123	ABC	10
	CD15	123	ABC	10
	CD16	123	ABC	10
	CD17	123	ABC	10
Location 3	GH11	123	ABC	10
	GH12	123	ABC	10
	GH13	123	ABC	10
	GH14	123	ABC	10
	GH15	123	ABC	10
			Total	200

Elias_Nordlinder

Hello again @Abhii2658 ,

Thank you for your additional input.

I have created a new workflow with the additional requirements.

1. Added a Count separately, joined it back to the original after have created the count

column, to keep all the original rows.

2. Kept all the rows after the join instead of removing the additional fields.

//Let me know if this better works for your data 🙂

Regards

Elias

Creating Complex Pivot Tables.yxmd