Creating a Relative Frequency table

[Chitemerere]

I have the following dataset in a table named 'Major Funding':

Word

government

donors

igf

government

government

donors

igf

government

donors

no budget yet

government

donors

igf

self-funded

government

donors

no budget yet

government

donors

government

government

government

donors

government

donors

private sector

government

donors

self-funded

government

government

donors

self-funded

self-funded

donors

self-funded

donors

self-funded

government

government

government

donors

government

donors

self-funded

government

donors

self-funded

government

donors

government

donors

government

self-funded

government

self-funded

donors

self-funded

government

donors

self-funded

donors

self-funded

I then create a measure called RowCountMajorFunding = COUNTROWS('Major Funding')

I then plot a chart of 'Word' as x-axis and 'RowCountMajorFunding' as 'Values' to get the following visual:

How can the above chart be converted into a 'Relative Frequency' chart so that it shows % instead of absolute numbers?

Thanking you in advance.

Chris

[amitchandak · Accepted solution]

@Chitemerere ,

You can try a measure like

RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),allselected('Major Funding')))
or
RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),all('Major Funding')))

[Chitemerere]

Many thanks, works like a charm

Regards,

Chris