CountIf problem

[gokhanirdam]

Dear All, 

I want to count number of text in a column including 3 different text ( "A", "B","C"). However I want to count texts distinctly according to other 3 different dimensions. ( "Part number", "Operation no", "Alternative no"). 

For example, below table should give me 2 "A", 1 "B" as a result.

And after this, I want to show result in a pie chart  regarding numbers of "A", "B", "C".

Thanks for help.

PART NO	OPERATION NO	ALTERNATIVE NO	STATUS
2332987	10	1	A
2332987	10	1	A
2332987	20	1	A
3040403	50	2	B

[hornstrup]

Hi,

How about using "STATUS" as the Dimension in your Piechart and then a measure like this:

Count(Distinct [OPERATION NO]&[PART NO]&[ALTERNATIVE NO])

Should give you the Piechart you need?

All the best, 
Jan