Percentages in List Report

[gatorfe]

Hello, we have a sales orders report that counts the lines of where the orders comes from  (eg:phone, internet).  So for example there are 106 totals lines for two of the ways orders come in for June.  102 are phone and 4 are internet.  How can we show that information in % format, 96% for phone and 4% for internet?  We do want to keep the counts showing on the report.  We have attached a pic of the output of the list report.  Thanks in advance for any suggestions.

[Francis aka khayman]

are you using dimensional or relational source?

[gatorfe]

Relational

[raj_aries81]

Hi gatorfe,

I am assuming the dataitem name that contains Phone & internet to be [Order Method]. So please try something like this -
Total([orders] for [Order Method])/Total([Orders]) and then use the format option to change it to %

Regards
Raj