Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Percentage Distribution

Hello All,

I need to Calculate percentage distribution.

percentage distribution =  number of  "CHRG_SOLD"  for  each "CHRG_STATE_CODE"  /  total number of CHRG_SOLD in the US for the State "CHRG_STATE_CODE"

We are using SQL Server as the DB

I am providing sample data for your reference. Kindly help

CHRG_STATE_CODE            CHRG_SOLD

CA                                                52

CA                                                31

MI                                                  44

MI                                                  60

MI                                                   70

Best Regards

Sandeep

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question