Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thanks in advance.
Best regards,
Dilip
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.
Regards
Hi nikolaos,
I need soluation in expression label.
Regards
Dilip
Hi dilipmantu,
I dont think it is possible to do that in expression label with the current form of your model.
Regards
hi
attach is what you asked for
hope it helps you
Hi Baram,
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.
Best regards,
Dilipmantu
Hi Baram,
We are waiting for your reply till now.
Please look into this.
Thanks and regards,
Dilipmantu
Hi Baram,
We are waiting for your reply till now.
Please look into this.
Thanks and regards,
Dilip Dolui