Hello,
This might be a straight pivot table question but posting here as my data is in Power Pivot.
I need to find the grand-total of a sub-column.
So, in the example XLS, (I just went and grabbed some census data) I would like to have the grand total of whites and blacks as the last right 2 columns of the pivot table.
Is this possible?
Thanks,
Alex
I'd like the pivot table to look like:
<tbody>
</tbody>
currently the pivot table fields look like:
<tbody>
</tbody>
<tbody>
</tbody>
This might be a straight pivot table question but posting here as my data is in Power Pivot.
I need to find the grand-total of a sub-column.
So, in the example XLS, (I just went and grabbed some census data) I would like to have the grand total of whites and blacks as the last right 2 columns of the pivot table.
Is this possible?
Thanks,
Alex
I'd like the pivot table to look like:
<tbody> </tbody> |
<tbody>
</tbody>
currently the pivot table fields look like:
COLUMNS | VALUES |
ENROLLMENT | Sum of POPULATION |
whiteORblack |
<tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>