Forum Discussion

vt_excel's avatar
vt_excel
Copper Contributor
Jan 15, 2023

Applying pivot and combining few of its columns

1. Have a dataset below, when I apply pivot I want that last three columsn get combined as in final result, is it possible?   Customer Name Manufacturer Item Order Date Bill Date Amount ...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 15, 2023

vt_excel That could be with Power Pivot. Demonstrated in the attached file.

 

vt_excel's avatar
vt_excel
Copper Contributor
Jan 15, 2023

Riny_van_Eekelen 

Thanks for inputs.

 

1. When i try to put filter on pivot table, and arrange in ascending order for either name, manufacturer or item, consolidated columns goes away

 

before filter

 

 

 

 

 

After filter 

 

 

2. ALso whats the formula applied to combined item?

 

Resources