Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |