on 10-15-2012 9:18 AM
Hi all,
I need to get the % of each month that appears in a report. I mean, for each month, the sum of values included has to be 100%.
If I build the report and I put period in rows, it's been calculated ok:
But if I put period in columns (what is actually what customer wants), it's not working:
I've tried NODIM but it's not working, and searching on forums and other discussions I couldn't find any solution.
Can you help me with this? You'll be rewarded
Thanks!
Hi Alerto ,
Facing the same kind of problem.
But only different is % values are splitted as shown below.
Month1 | Month1 | Month2 | Month2 | |||
Month => | 13-Nov | 13-Nov | 13-Dec | 13-Dec | Overall Result | |
City | Customer Count | Count % | Customer Count | Count % | Customer Count | Count % |
Mumbai | 5 | 21.74% | 6 | 26.09% | 11 | 47.82% |
Delhi | 3 | 13.04% | 4 | 17.39% | 7 | 30.44% |
Chennai | 2 | 8.70% | 3 | 13.04% | 5 | 21.74% |
Total | 10 | 43.48% | 13 | 56.52% | 23 | 100% |
Whereas my requirement is to calculate % along each month (pl.find the given attachement)
Month1 | Month1 | Month2 | Month2 | |||
Month => | 13-Nov | 13-Nov | 13-Dec | 13-Dec | Overall Result | |
City | Customer Count | Count % | Customer Count | Count % | Customer Count | Count % |
Mumbai | 5 | 50% | 6 | 46.15% | 11 | 47.82% |
Delhi | 3 | 30% | 4 | 30.77% | 7 | 30.44% |
Chennai | 2 | 20% | 3 | 23.08% | 5 | 21.74% |
Total | 10 | 100% | 13 | 100% | 23 | 100% |
Thanks in advance.
Girish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.