Percentage
Hi,
I guess this is not that difficult but I'm not getting to solve it.
I have a pipeline with some currency values (value) and each record is
regarded to some place (place_id). I want to group by place_id and in each
line show the value and the percent relative to that value.
Just to clarify the issue, there goes an example:
PLACE 1
R$ 90,00 90%
R$ 10,00 10%
--------------------
T: R$ 100,00 100%
PLACE 2
R$ 130,00 65%
R$ 70,00 35%
---------------------
T: R$ 200,00 100%
I don't know if it is clear, but any help will be apreciated.
Thanks
Ricardo
I guess this is not that difficult but I'm not getting to solve it.
I have a pipeline with some currency values (value) and each record is
regarded to some place (place_id). I want to group by place_id and in each
line show the value and the percent relative to that value.
Just to clarify the issue, there goes an example:
PLACE 1
R$ 90,00 90%
R$ 10,00 10%
--------------------
T: R$ 100,00 100%
PLACE 2
R$ 130,00 65%
R$ 70,00 35%
---------------------
T: R$ 200,00 100%
I don't know if it is clear, but any help will be apreciated.
Thanks
Ricardo
This discussion has been closed.
Comments
The following example shows how to display a running percentage of the
total. Be sure you have your report set to TwoPass.
http://www.digital-metaphors.com/tips/percentage.zip
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com