Percent of Total Calculation

Question & Answer
, ,
1

Hi Community,

I have a table (see below) and I want to calculate the percent of total for each month/row

image
image494×286 14.3 KB

For example, December 24 should be

column 1: 100%
column 2: 1074/1312 = 82%
column 3: 72/1312 = 5%

I have tried the table calculation but have been unable to isolate the calculation to the row.

Thanks!

1 Like
2

Hello @daynamccue, I know our data isn’t exactly the same, but I think I have 2 different options that you could utilize to solve this issue. The first pivot table is utilizing the table calculation that you can apply directly on the field well, and the 2nd pivot table uses a calculated field to achieve the result.

Percent of Total Calculation

Let me know if this helps you achieve what you were looking for, otherwise let me know if you have any further questions. Thank you!

3

hello @daynamccue

have you ever try the formula:
percentOfTotal(aggregated measure, [partition by attributes] )

let me know if it’s work!!

4

Hello @daynamccue, since we have not heard back from you with any remaining questions, I will mark my previous response as the solution. Let me know if you have any follow-up questions on the Arena analysis that I linked and I can guide you further. Thank you!