Excel - Count function in Excel (troubleshoot)

$30-100 USD

Cancelled

Posted

over 16 years ago

$30-100 USD

Paid on delivery

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

About the project

14 proposals

Remote project

Active 17 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

14 freelancers are bidding on average $42 USD for this job

@sanath1978

PLease contact me

$30 USD in 1 day

5.0

(13 reviews)

5.5

@johnsinit

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

$30 USD in 1 day

4.8

(16 reviews)

4.2

@hiratariq

Hi! Please see PM.

$30 USD in 1 day

5.0

(9 reviews)

4.1

@Peterpay

see pmb for more details

$30 USD in 0 day

4.8

(10 reviews)

3.8

@crayons

hello, plz chk pmb for details. Crayons

$45 USD in 0 day

5.0

(1 review)

3.4

@ramvinod

i can do it

$100 USD in 1 day

5.0

(1 review)

3.3

@IrfanKhowaja

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

$50 USD in 1 day

0.0

(0 reviews)

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 in 7 days

0.0

(0 reviews)

0.0

@amitatewari

Please refer to PMB for clarifications.

$30 USD in 1 day

0.0

(0 reviews)

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 in 1 day