I have a report where I am currently having City , Month and Sales(in $) calculation. I need to another '% change of Sales' calculation on the report which is defined as
% Change
= ((Current Month Sales â€" Prior Month Sales)/Prior Month Sales )* 100
Please advice how to do it.
Thanks in advance.
Hi
Are you using DMR or a relational data source?
If you have DMR and have the current_month and prior_month as data items the calculation is pretty simple using a tuple comand something like
You will need to use a crosstab for this
((tuple([current_month],[sales])-tuple([prior_month],[sales]))/tuple([prior_month],[sales]))*100
If you're not using DMR you will probably need to have a couple of sub queries one with current month sales and the other with prior month sales, bring them into a crosstab and then use a similar calculation to the one above
Hi wyconian , thanks a lot for the reply.
I am using a DMR. Can the calculation be used on a List report or does it have to be a Crosstab?
Hi
I think you need to use a crosstab but I could be wrong