excel - Pivot Table Field has no items -

-

i working on series of pivot tables on excel, particular filter automated in following way: user inputs particular value in 1 cell, , filters across workbook refresh accordingly. have been reading posts in stack exchange explain how it. however, have come across issue have been unable solve.

my data comes external microsoft access database. have created connexion between database , excel file; data imported excel file displayed table tblexcel. pivot tables linked tblexcel.

to refresh filters, want use following line:

item.visible = (item.caption = cd)

where item pivotitems object , cd value inputted user. line wasn't working, wrote following subroutine check something:

sub test()  check = 0  each field in application.activeworkbook.worksheets("sheet1").pivottables("pivottable").pivotfields("[tblexcel].[field1].[field1]").pivotitems     check = check + 1 next  msgbox check  end sub

it turns out msgbox returns invariably 0, fields, empty.

does know why happening? due data model structure? how circumvent it?

try following code, debug purposes have inputbox, write down field1 value want pivot table filter to.

option explicit public sub filter_pivottable_items()  dim pvttbl                              pivottable dim pvtfld                              pivotfield dim cd                                  string  ' setting pivot table pivottable object set pvttbl = activeworkbook.worksheets("sheet1").pivottables("pivottable")  application.screenupdating = false  ' set pivot table show selected project's data set pvtfld = pvttbl.pivotfields("field1")  ' select manually value field 1 >> debug purpose cd = inputbox("select item") call selectpivotitem(pvtfld, cd)  end sub   public sub selectpivotitem(field pivotfield, cd string)  dim item                            pivotitem  on error goto cd_error each item in field.pivotitems     item.visible = (item.caption = cd) next  cd_error: if err.number = 1004     msgbox "item " & cd & " not found !"     exit sub end if  end sub

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more