Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
How to calculate Total Percent
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-14-2018 10:14 PM
Hi Everyone,
I would like to create a table like below. Could you provide me some suggetion about this? Thank you in advance!
Regards,
Kelly
Solved! Go to Solution.
Accepted Solutions
Highlighted
Re: How to calculate Total Percent
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-15-2018 02:46 AM
This MEASURE should get you desired result
Percent = SUM ( Table1[Column B] ) / SUM ( Table1[Column C] )
All Replies
Highlighted
Re: How to calculate Total Percent
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-15-2018 02:46 AM
This MEASURE should get you desired result
Percent = SUM ( Table1[Column B] ) / SUM ( Table1[Column C] )
Re: How to calculate Total Percent
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-15-2018 09:34 PM
Thanks for your help!!!