SF Report Query

[former_member124913]

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

[xavierlegarrec]

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