cancel
Showing results for 
Search instead for 
Did you mean: 

SF Report Query

former_member124913
Discoverer
0 Kudos

Hello Experts,

How to configure a report to give SUM of distinct values.

I tried to configure the same in Ad-hoc report and Canvas report but we are getting sum of all values instead of the required SUM of distinct values.

Can you please suggest further.

Thank You

Sanket

Accepted Solutions (0)

Answers (1)

Answers (1)

xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi sanket_d2022

I don't think it is possible in Adhoc report, only in Advanced reporting or People Analytics. I believe my colleague Christian shows how to do that in her stories here :

https://blogs.sap.com/?p=1584058

https://blogs.sap.com/?p=1620234

All the best

Xavier