ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pivot table - %structure with subtotals (https://www.excelbanter.com/excel-programming/288753-pivot-table-%25structure-subtotals.html)

Mark[_17_]

pivot table - %structure with subtotals
 
I want create structure percent in some column of
pivottable.
I create field in pivottable: CalculatedFields.Add
with ...
.Calculation = xlPercentOfColumn
it's work fine but..
i did early subtotals (by VBA) in source data of pivot
table and structure% (in pt) is incorrect.
Unfortunately in pt:
..Function = False
..ColumnGrand = False

don't produce effect.

Any help will by appreciate

Regards
MArk


All times are GMT +1. The time now is 10:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com