Possible in pivot?

[sharshra]

I have the following table. On this, I have to count the mod & number of `no´ against each mod. I´m able to get the desired output using the combination of pivot table & formula. However, I´m curious to know if same result can be achieved using pivot only without using formula. Can the experts advise please?

Base table -

search problem.xlsx
	B	C	D	E
2	#	Mod	Desc	TC
3	1	C	dfd	2
4	2	L	dvsv	no
5	3	A	erer	no
6	4	L	hgh	1
7	5	L	uiyui	9
8	6	L	czc	no
9	7	C	cvnv	21
10	8	C	4rf	36
11	9	C	34ref	no
12	10	L	erer	3
Sheet2

Pivot + formula column
I´m using a combination of pivot table & formula to get the count of mod, count of TC & count of TC having `no´.

search problem.xlsx
	H	I	J	K
1	TC	(All)
2
3	Mod	Count of Mod	Count of TC	no
4	A	1	1	1
5	C	4	4	1
6	L	5	5	2
7	Grand Total	10	10	4
Sheet2

Cell Formulas
Range	Formula
K4:K6	K4	=LET( mod,$C$3:$C$12, tc,$E$3:$E$12, ROWS(FILTER(mod,(mod=H4)*(tc="no"))))
K7	K7	=SUM(K4:K6)

 

[alansidman]

With Power Pivot, write a measure

=countx(
Filter(Table1,Table1[TC]="no"),
Table1[TC]
)

Call this Count of TC and then put it in the values in the Pivot Table.

 

[sharshra]

Thank you very much, @alansidman I´m wondering why I didn´t think about power pivot