Hi all, I am having trouble with the consolidation of my named ranges into the one pivot table to finish a dashboard. I have got all the named ranges into the data source. Each named range is the same shape: that is, each consists of 4 columns. Columns are Amount, Animal, Location, and Colour. I only want Amount and Source for the dashboard. I haven't used consolidated ranges before so don't actually know much about them. The resulting pivot table from the consolidated ranges gives a total for each of the intervening columns as well as a total for the Source.
<tbody>
</tbody>
I included the field headers above for clarity.
What i want is :<!-- Please do not remove this header --><!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) -->
<tbody>
</tbody>
Is it possible with multiple consolidated named range pivot tables to exclude columns, or will i have to do this another way?
what are the options? make new named ranges that consist of only the two columns?
Row Labels | Sum of Row | |
---|---|---|
Animal | Sheep | $ 5.06 |
Colour | Sheep -Black | $ 1.01 |
Colour | Sheep - White | $ 1.73 |
Colour | Sheep - Mixed | $ 2.32 |
Location | Paddpock 1 | $ 1.27 |
Location | Paddock 2 | $ 3.80 |
Grand Total | $ 15.19 |
<tbody>
</tbody>
I included the field headers above for clarity.
What i want is :<!-- Please do not remove this header --><!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) -->
Row Labels | Sum of Row |
---|---|
Sheep -Black | $ 1.01 |
Sheep - White | $ 1.73 |
Sheep - Mixed | $ 2.32 |
Grand Total | $ 5.06 |
<tbody>
</tbody>
Is it possible with multiple consolidated named range pivot tables to exclude columns, or will i have to do this another way?
what are the options? make new named ranges that consist of only the two columns?