Hi, what im trying to do is divide the different values in a column by the total sum of all the values in a certain area
For example in the secound group of rows i would like to divide 218 by the total sum of that same column (5843) so i can get the % of that amount in that group.
I have been trying the following where Por2 is this:
lookup(COUNT([Total]), first())/lookup([SumaTotal], first())
im dividing the count of total by the total sum of this counting but all im getting is the sum of the same row.
Any ideas on how to do this?
thanks in advance
Hi Juan,
This can be by editing the calculation so that it looks similar to the following:
lookup(count([Total]), first())/total(count([Total]))
Then, place this on the view. Right click on it and select Compute Using-->Pane (Down).
Hope this helps!
-Tracy