Thanks in advance.
Hi there dilipmantu,
The solution to your problem is to calculate your indicator on the script(or possibly on the sql query by using sum(2012)-sum(2013) )and then
you could easily create your prefered table.
Thank you very much for looking into our problem and sending the application. The "Summary Report" is almost OK.
However a little bit more effort is required. Please address the problem in the "Main Report" first where the percentage values for each indicator ('Growth'/'Degrowth'/'Nogrowth' depending on the values of the first and second measure columns) need to be displayed. Naturally these values will repeat many times. Once this is done then the next report (Summary) can be done based on it where the indicators will act as dimension.
Please note some points:
1. The inline data for "S" in the script is given for example only. In reality there will not be such thing. Those percentage values will be obtained on-the-fly from the first report (i.e. with the caption: 'Main Report').
2. While calculating the percentage value, please don't divide by "count(DISTINCT Customer)" which is a static value. It should be the total number of displayed customer records in the "Main Report".
Please do reply us if you need any more information regarding this.
Again thanks a lot for your time.