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.
are you using dimensional or relational source?
Relational
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