Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I am trying to create some calculations that show me the percent of total for a specific type of meeting.
I have illustrated what I need in paint, take look at the attached screenshot.
The calculations to the right with % are the ones that I want to calculate. How do I go about?
Kind regards
AV
Hello,
You can create 4 individual measures which follow like:
Count({<[Type of Meeting]={'e-mail'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Count({<[Type of Meeting]={'Face to Face'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Count({<[Type of Meeting]={'One to One'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Count({<[Type of Meeting]={'Telephone'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Edit:
If you may want to keep the 'Type of Meeting' dimension in the table, you need to add THIS.
I hope this helps!
Kind regards,
S.T.
Hello,
You can create 4 individual measures which follow like:
Count({<[Type of Meeting]={'e-mail'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Count({<[Type of Meeting]={'Face to Face'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Count({<[Type of Meeting]={'One to One'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Count({<[Type of Meeting]={'Telephone'}>} [Total Meetings])/ Count(Total <Account> [Total Meetings])
Edit:
If you may want to keep the 'Type of Meeting' dimension in the table, you need to add THIS.
I hope this helps!
Kind regards,
S.T.
Fantastic! It worked just amazing. Thank you very much!!