Excel - Count function in Excel (troubleshoot)

$30-100 USD

İptal edildi

İlan edilme:

16 yıldan fazla önce

$30-100 USD

Teslimde ödenir

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

Proje No: 187891

Proje hakkında

14 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 17 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

14 freelancer bu proje için ortalama $42 USD teklif veriyor

@sanath1978

PLease contact me

$30 USD 1 gün içinde

5,0

(13 değerlendirme)

5,5

@johnsinit

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

$30 USD 1 gün içinde

4,8

(16 değerlendirme)

4,2

@hiratariq

Hi! Please see PM.

$30 USD 1 gün içinde

5,0

(9 değerlendirme)

4,1

@Peterpay

see pmb for more details

$30 USD 0 gün içinde

4,8

(10 değerlendirme)

3,8

@crayons

hello, plz chk pmb for details. Crayons

$45 USD 0 gün içinde

5,0

(1 değerlendirme)

3,4

@ramvinod

i can do it

$100 USD 1 gün içinde

5,0

(1 değerlendirme)

3,3

@IrfanKhowaja

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

$50 USD 1 gün içinde

0,0

(0 değerlendirme)

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 gün içinde

0,0

(0 değerlendirme)

0,0

@amitatewari

Please refer to PMB for clarifications.

$30 USD 1 gün içinde

0,0

(0 değerlendirme)

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 gün içinde