Excel - Count function in Excel (troubleshoot)

$30-100 USD

취소됨

게시됨

16년 이상 전

$30-100 USD

제출할때 지불됩니다

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

프로젝트 ID: 187891

프로젝트 정보

14 제안서

원격근무 프로젝트

활동 중 17년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

14 이 프로젝트에 프리랜서들의 평균 입찰은 $42 USD입니다.

@sanath1978

PLease contact me

$30 USD 1일에

5.0

(13 건의 리뷰)

5.5

@johnsinit

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

$30 USD 1일에

4.8

(16 건의 리뷰)

4.2

@hiratariq

Hi! Please see PM.

$30 USD 1일에

5.0

(9 건의 리뷰)

4.1

@Peterpay

see pmb for more details

$30 USD 0일에

4.8

(10 건의 리뷰)

3.8

@crayons

hello, plz chk pmb for details. Crayons

$45 USD 0일에

5.0

(1 건의 리뷰)

3.4

@ramvinod

i can do it

$100 USD 1일에

5.0

(1 건의 리뷰)

3.3

@IrfanKhowaja

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

$50 USD 1일에

0.0

(0 건의 리뷰)

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 7일에

0.0

(0 건의 리뷰)

0.0

@amitatewari

Please refer to PMB for clarifications.

$30 USD 1일에

0.0

(0 건의 리뷰)

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 1일에