pivot table configuration

nikhil83

New member
Joined
Jul 27, 2013
Messages
16
Reaction score
0
Points
0
Hi,

from the file uploaded , i need to generate following summery report . How do i configure pivot table to get this ?

Total Freepool Working on Angular Exit
IT Services11263
Arista9090
AppviewX1000
Maple1000
Total222153

In some cases numbers may not add up to total . Don't bother about it.

If the data appeares jumbled,see this pls
Coloumn headings - Total,Free pool,Working on Angular,Exit
 

Attachments

  • Angularlist1.xlsx
    16 KB · Views: 26
Hi

Your data is in the wrong format to achieve the results you want with a Pivot Table.
I have used Power Query to Unpivot your data, then added an extra column to the Table called Result (see Sheet 3 in attached file)
This fills in Exit, if the value is E, or the name of the Group if the Value is Y and ignores any values of N
=IF([@Value]="E","Exit",IF([@Value]="Y",[@Group],""))

Then pivoting this new table in the way shown produces your result

Count of ResultResult
UnitFreePoolAngularExit
IT Services263
Arista9
Maple
AppviewX
Grand Total2153
 

Attachments

  • Angularlist1 #2.xlsx
    33 KB · Views: 36
Hi

Your data is in the wrong format to achieve the results you want with a Pivot Table.
I have used Power Query to Unpivot your data, then added an extra column to the Table called Result (see Sheet 3 in attached file)
This fills in Exit, if the value is E, or the name of the Group if the Value is Y and ignores any values of N
=IF([@Value]="E","Exit",IF([@Value]="Y",[@Group],""))

Then pivoting this new table in the way shown produces your result

Count of ResultResult
UnitFreePoolAngularExit
IT Services263
Arista9
Maple
AppviewX
Grand Total2153

Thank you so much . That was of great help.
 
Back
Top