How to do multiple counts for unique rows?

[wuming79]

Hi,

I have a table as below:

Name	Fruits	Amt Spent
John	Apple	1
John	Apple	1
John	Orange	3
John	Banana	4
John	Orange	3
Adam	Apple	1
Mary	Apple	1
Mary	Orange	3
Adam	Pear	2
Mike	Banana	4

I tried

dimension field = Name

dimension field = Count(distinct Fruits)

dimension field = Sum(Amt Spent)

but I keep getting errors like invalid dimension.

How do I make a table on my sheet that will count the number of fruits bought and also sum the total spent?

Example:

Name	No of Fruits bought	Total Spent
John	4	12
Adam	1	1
Mary	2	4
Mike	1	4

[Ivan_Bozov · Accepted solution]

Try Sum([Amt Spent]). There is a space in the name, that is why you need brackets.

Also create columns 2 and 3 as measures, not as dimensions.