OK to me this should be simple, but I can't get Excel to do what I want :S
Rows: Name
Columns: Month, SalesType
Value: Amount
So what currently happens is that it splits the amounts by Month then by SalesType.
What I'd like to do is have a final column at the end totalling it by SalesType.
Is this possible? Or should I use functions to derive my result?
Rows: Name
Columns: Month, SalesType
Value: Amount
So what currently happens is that it splits the amounts by Month then by SalesType.
What I'd like to do is have a final column at the end totalling it by SalesType.
Is this possible? Or should I use functions to derive my result?
