Calculate Based off Column Total ONLY

[hsackman]

Hello,

I'm trying to get a weighted conversion based off the total of a different measure. 

'Measure' is taking the count of agent ID over 'Paid Leads', but I only need the total. Problem is 'Count of AgentID' is a different data set so it is not tied to the indicators of each line. 

I need to use the total of 'Mesaure' divided by the total of 'Conversion' multiplied by each lines conversion to weight it appropriately.  

Line 1 example:  = (0.32 / 18.0%) * 24.1% = 43.5% 

The goal would be to do that for each line.

Is there a way to do this?

[Thennarasu_R]

HI @hsackman 

Its Possible we can do.Below i mentioned the measures . You can this one . I put some refference name instead that one you can change respective measures.

Measure=Divide(Measure ,Sumx(Values(Categorycolumn),Conversion Measure)

Thanks
Thennarasu R

[hsackman]

I can't seem to input the Categorycolumn, that too is a created measure/calculation. How do I do this?

[Thennarasu_R]

@hsackman 

Then in table visuals how measures are spilt .We have one column that u used in first column based on that column all measues values are spilt .

I dont know that one instead of that i said like Category whatever column you have mention over there.

Thanks,
Thennarasu R