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

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Percentage of Total
05-07-2018
01:34 PM
How can I calculate the percentage of a row value out of the total of the column of said value, with the total of the column being absolute and not changing relative to filters or fields? The normal SUM function calculates the total, but changes depending on the date or any other filter.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2018
04:25 PM
Hi,
A measure like this should help
=SUM(Data[Amount])/CALCULATE(SUM(Data[Amount]),ALL(Data))
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2018
10:42 AM
Not exactly, but I found the problem, my domain was not continuous and so any sum measure would just add it per category and not progressively.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
10-29-2024 09:52 AM | |||
11-20-2024 08:10 AM | |||
11-01-2024 01:56 AM | |||
07-19-2024 04:49 AM | |||
02-12-2025 01:27 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |