Is there a way in a pivot table, or using powerpivot, that I can have multiple columns of data, each filtered differently?
The below output filters out name and activities that I do not want to see. I would like to add a new column that displays the sum of hours for the items that I filtered out in the first column. Is this even possible?
Row Labels Sum of Hours
Brandon 116.5
* Hosting MS 44
* Network MS 18.5
* Network PS 49
* Virtualization 5
Matthew 89
* Hosting MS 23.5
* PC Services 1
* Systems Services 59.5
* Virtualization MS 4.5
* Virtualization PS 0.5
The below output filters out name and activities that I do not want to see. I would like to add a new column that displays the sum of hours for the items that I filtered out in the first column. Is this even possible?
Row Labels Sum of Hours
Brandon 116.5
* Hosting MS 44
* Network MS 18.5
* Network PS 49
* Virtualization 5
Matthew 89
* Hosting MS 23.5
* PC Services 1
* Systems Services 59.5
* Virtualization MS 4.5
* Virtualization PS 0.5
