Hi,
I have data like this in xcelsius data sheet,
A B C
1 State Month Sales
2 Austin Jan 200
3 Austin Feb 300
4 Austin Mar 400
5 Texas Jan 400
6 Texas Feb 200
7 Texas Mar 500
8 DC JAn 100
9 DC Feb 300
10 DC Mar 150
I want to aggregate the sales values in the following format,
H I J K
1 State Jan Feb Mar
2 Austin 200 300 400
3 Texas 400 200 500
4 DC 100 300 150
I used SUMIFS function, unfortunately Xcelsius does not support this function.
Is there any work around to get the values in desired format using Excel functions.
Sorry in the preview the format is not shown properly, but iam looking for something like crosstab report format.
Regards
Sudhakar