Skip to Content
0

Sum of Rows and Columns in a Report

Feb 13 at 08:52 AM

131

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vinita Sinha
Feb 13 at 06:20 PM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Vinita,

Thanks a lot for providing the information, it worked. However, there is a small issue in the calculated Result.

I've used a 'Condition' to display only top 3 Category value but the result includes count of hidden category columns as well (Image attached)err.png

Our requirement is to display sum total of only Top 3 Categories. Is this behavior possible?

Thanks in advance.

Regards,

Mohit

err.png (24.9 kB)
0

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

0