If function not accepting text in calculated field of pivot table

[INN]

Hi
I want to create a calculated field in pivot table and to use this function

= IF('Amount Sold' >7,"good","bad")

But I got an error message #Values, but if I use this function

= = IF('Amount Sold' >7,1,2)

I get 1 and 2 based on the value of Amount Sold. Why text is not accepted in If fucntion in Pivot table? Thank you very much

Name	Item	Amount Sold	Region			Row Labels	Sum of Amount Sold	Sum of Field1
Mary	A	10	East			A	10	1
Raj	B	5	West			B	5	2
Jack	D	5	East			C	10	1
Bob	C	10	Cental			D	5	2
						Grand Total	30	1

 

[INN]

.

 

[Alex Blakenburg]

In a regular pivot the calculated field is a "Value" field and it expected to be number to which you can apply Sum, Avg, Min, Max etc.
You may be able to do what you want if you load the data into the datamodel and use DAX.

 

[INN]

Thank you. It took me long time to understand what you said above. When I read again now, it makes perfect sense. Thanks for all your help.

 

[Alex Blakenburg]

Thanks for the follow up. Please let us know when an explanation doesn't work for you, perhaps we can use a different example or approach or perhaps a different person will answer and use different terminology. We are here to help.