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


CA                                                52

CA                                                31

MI                                                  44

MI                                                  60

MI                                                   70

Best Regards


Former Member

Helpful Answer

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