This content has been marked as final.
Show 1 reply

1. Re: Dividing each column by a column grand total
Yahia Imam Jun 30, 2016 11:48 AM (in response to Jon Stoessel)Hi Jon,
You can create one calculation using FIXED {Fixed : sum(field)} to calculate the total of the column as an entry on each row. Then use that in a new calculation to divide your desired data by the total of the column. I attached a very simple example. You may need to add a dimension to the fixed formula depending on your data.
The raw data is in the 'Data' field, Fixed formula in the 'Sum of data' field and the output is under 'Desired output'
If you upload a sample of your data, I can try to help you out with it.
Cheers,
Yahia

Divide1.twbx 12.3 KB
