Excel - Count function in Excel (troubleshoot)

$30-100 USD

Inställt

Publicerad

över 16 år sedan

$30-100 USD

Betalning vid leverans

Hello, Please see the screenshot attached. I'm having an issue with the Count function in a Pivot Table. When I filter either fields ('Fair and Impartial Treatment' or 'Treating Employees with Respect'), then doing so will affect the other. Is there a way, by either some sort of calculated Item/Field or something, to run a count of a field in a pivot table without being affected by the filtering of any other fields? In the screenshot, let's say I filter 'Fair and Impartial Treatment' to see the values "1,2,3 and 4", you can see if I filter out the values that are empty (the value "")...then that will remove the adjacent rows under the column 'Treating Employees with Respect'. I have been looking at this for several hours now, and I really don't know what to do. Can anyone help with this? Thanks

Data Entry

Data Processing

Visual Basic

Project ID: 187891

Om projektet

14 anbud

Distansprojekt

Senaste aktivitet 17 år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

14 frilansar lägger i genomsnitt anbud på $42 USD för detta uppdrag

@sanath1978

PLease contact me

$30 USD Om 1 dag

5,0

(13 omdömen)

5,5

@johnsinit

Dear nextlevelmedia! I am an experienced VBA programmer. Would be happy to help you. Please, check PMB.

$30 USD Om 1 dag

4,8

(16 omdömen)

4,2

@hiratariq

Hi! Please see PM.

$30 USD Om 1 dag

5,0

(9 omdömen)

4,1

@Peterpay

see pmb for more details

$30 USD Om 0 dag

4,8

(10 omdömen)

3,8

@crayons

hello, plz chk pmb for details. Crayons

$45 USD Om 0 dag

5,0

(1 omdöme)

3,4

@ramvinod

i can do it

$100 USD Om 1 dag

5,0

(1 omdöme)

3,3

@IrfanKhowaja

I can do this. Have a start. I assure to give you the best.

$50 USD Om 1 dag

0,0

(0 omdömen)

0,0

@fashionsoft

I'm a system analyst of a software company and at present doing some freelance works for the valuable clients who would like to work with me. I'm very interested in your project and exactly capable of providing the works in time within budget. I'm committed to the quality of the works. Hope to see you soon and waiting for a sensible reply from you. Best Regards, Sumon

$50 USD Om 7 dagar

0,0

(0 omdömen)

0,0

@amitatewari

Please refer to PMB for clarifications.

$30 USD Om 1 dag

0,0

(0 omdömen)

0,0

@richardgb

If all you're wanting is a count of various field items I'd suggest a fixed table of values which uses either a countif function, or perhaps if permutations of field counts are needed, by using the little used and not very well understood Sumproduct function. I much prefer these methods than manipulating pivot tables, which in my opinion are less flexible for this sort of thing. That's not to say that pivot tables are not extremely powerful and useful, just that they're not the best for all occasions. Rgds

$30 USD Om 1 dag