Hi,
I have a pivot table that displays a number of stock positions, sorted by Industry. For some of the data fields, I want subtotals, but for others, the subtotals would be meaningless and I'd like them not to display. For example (sorry about the imperfect formatting):
-----------------Units----Price----MarketValue
+Technology ___________________$800
MSFT___________10______20_____$200
AOL____________ 20______30_____$600
+OIL & GAS ___________________$3200
Etc.
Notice in the above, the Market Value sums up to a subtotal (technology=800), but I do not want totals to dispaly for units or price. Is there a way to implement this? For now I have set the text color manually to white to hide them, but this is unstable and I believe will break down as new subcategories appear on the chart.
Anybody have a good solution?
Thanks,
Ben
I have a pivot table that displays a number of stock positions, sorted by Industry. For some of the data fields, I want subtotals, but for others, the subtotals would be meaningless and I'd like them not to display. For example (sorry about the imperfect formatting):
-----------------Units----Price----MarketValue
+Technology ___________________$800
MSFT___________10______20_____$200
AOL____________ 20______30_____$600
+OIL & GAS ___________________$3200
Etc.
Notice in the above, the Market Value sums up to a subtotal (technology=800), but I do not want totals to dispaly for units or price. Is there a way to implement this? For now I have set the text color manually to white to hide them, but this is unstable and I believe will break down as new subcategories appear on the chart.
Anybody have a good solution?
Thanks,
Ben
Last edited: