How to do multiple counts for unique rows?

wuming79 — Wed, 17 Oct 2018 12:28:42 GMT

Hi,

I have a table as below:

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:

Re: How to do multiple counts for unique rows?

Ivan_Bozov — Wed, 17 Oct 2018 21:22:42 GMT

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.