pivot table - How can I shift the "subitems" in an Excel PivotTable to another column? -


i generate excel sheet contains data formatted so:

enter image description here

iow, "total packages", "total purchases", "average price", , "% of total" values located in column of own (data) each overarching (or sidearching) description.

when pivottablize data, places these values beneath each description:

enter image description here

this makes sense, accustomed previous appearance want replicated in pivottable. how can shift description "subitems" in pivottable own column?

this code use generate pivottable:

private void populatepivottablesheet() {     string northwest_corner_of_pivot_table = "a6";     addprepivottabledatatopivottablesheet();     var datarange = rawdataworksheet.cells[rawdataworksheet.dimension.address];     datarange.autofitcolumns();     var pivottable = pivottableworksheet.pivottables.add(                         pivottableworksheet.cells[northwest_corner_of_pivot_table],                          datarange,                          "pivottable");     pivottable.multiplefieldfilters = true;     pivottable.griddropzones = false;     pivottable.outline = false;     pivottable.outlinedata = false;     pivottable.showerror = true;     pivottable.errorcaption = "[error]";     pivottable.showheaders = true;     pivottable.useautoformatting = true;     pivottable.applywidthheightformats = true;     pivottable.showdrill = true;      // row field[s]     var descrowfield = pivottable.fields["description"];     pivottable.rowfields.add(descrowfield);      // column field[s]     var monthyrcolfield = pivottable.fields["monthyr"];     pivottable.columnfields.add(monthyrcolfield);      // data field[s]     var totqtyfield = pivottable.fields["totalqty"];     pivottable.datafields.add(totqtyfield);      var totpricefield = pivottable.fields["totalprice"];     pivottable.datafields.add(totpricefield);      // don't know how calc these vals here, have grab them source data sheet     var avgpricefield = pivottable.fields["avgprice"];     pivottable.datafields.add(avgpricefield);      var prcntgoftotalfield = pivottable.fields["prcntgoftotal"];     pivottable.datafields.add(prcntgoftotalfield); }

so there 1 rowfield ("monthyr") values such "201509" , "201510", 1 columnfield ("description") , 4 datafields, align themseles under description column field. want shift 4 fields right, own column, , description label vertically centered between 4 values left. [how] possible?

try changing layout of table with

pivottable.rowaxislayout xltabularrow pivottable.mergelabels = true

this result:

enter image description here

a little script in c# interop.excel. included using ;)

using microsoft.office.interop.excel; using system.runtime.interopservices; using excel = microsoft.office.interop.excel;  var excelapp = new excel.application(); excel.workbook wb = excelapp.workbooks.open(@"e:\42\testso.xlsx"); worksheet ws = wb.worksheets["sheetname"]; pivottable pt = ws.pivottables("dynamictablename"); pt.rowaxislayout(xllayoutrowtype.xltabularrow); pt.mergelabels = true; wb.save(); wb.close(); marshal.releasecomobject(ws);

-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou...
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun...
Read more