Skip to Content

Sum of Rows and Columns in a Report

report.png

Dear Experts,

I have a report for which i need to get the total of all values in individual rows and individual coloumns. Data Source= Ticket

Ex. In the attached image, Sum of all Buying (9+4) displayed below and for May (10+9) Displayed on the right hand side.

Do we have to create a new Calculated key figure to get this total?

Thanks,

Mohit

report.png (11.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 13 at 06:20 PM

    Hi Mohit

    You can use the characteristic settings to specify Result Row as 'Show' for both your characteristics - Show the results for Calendar Month as well as for Service Category and it should work

    Cheers !

    Vinita

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mohit

      I am not able to understand the Count of Hidden columns. Could you Unhide and share what you think is being added to the total ?

      Besides, coming to your requirement of showing only the top 3, yes, that should work. You need to ensure that the condition is based on a characteristic that is part of what is displayed (Eg Month/Calendar Year in my example below). I simulated something similar using Opportunity List - Month/Calendar Year and Status as characteristics and Count for the KF. As you can see, the totaling works fine, as well as the condition

      Regards

      Vinita