If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: % of Total Calculation  (Read 6927 times)


  • Guest
% of Total Calculation
« on: 14 Mar 2012 10:04:24 am »
Playing in a crosstab report in cognos analysis studio and i'm trying to create a custom calculation.

My cross tab looks at Volume sold of item by location by year broken down by month and also forecast sale volume by same cross section -

                                                 Col A                     Col B           Col C                Col D                  Col E
                                            Forecast Value |    Product A    |  Product B    |  Product C |     Total All Products
Location A | Month A |Yr             123                    123                123                  123                   12345

I want to calculate the forecast volume as a % of Total. If i were doing it in excel it would be something like


Is there anyway of writing a custom calculation like this ?