I am facing the below issue while working with ASPOSE. I am new to aspose and would appreciate some help on this. We need to display quarterly data across columns in excel. The number of quarters and investments is dynamic based on user prompt selection. For these quarters, we need to show a summation at the bottom. This summation should repeat across for all the quarters that show up on the report. I could get it to work if the quarters are displayed vertically but it doesn't work for quarters displayed horizontally. I tried the keyword horizontal but no luck.
Investment Name Q1 2009 Q2 2009 ..
abc 123 456 ..
xyz 123 456 ..
Total 246 912 ...