Hi Experts,
I am developing a standard report for my users.
Based on my scenario I have created a sample QVW as attached.
My actual data table is :
| Activity | Priority | LastYCount | ThisYCount |
| Incidents | P1 | 654 | 147 |
| Incidents | P2 | 842 | 258 |
| Incidents | P3 | 248 | 369 |
| Responses | P1 | 358 | 963 |
| Responses | P2 | 359 | 852 |
| Responses | P3 | 652 | 741 |
The display as requested by user is:
| Activity | Prirty | ThisY | LastY |
| Incidents | P1 | 147 | 654 |
| Incidents | P1-P2 | 405 | 1496 |
| Incidents | P1-P3 | 516 | 902 |
| Incidents | P2 | 258 | 842 |
| Incidents | Total | 774 | 1744 |
This display has subtotals for P1-P2 and P1-P3. To achieve this I have created a custom field and used the formulas as shown in the application.
However, I am unable to get the Grouped style chart working anymore. May be because of the formulas/functions I used.
Could you please suggest whats going wrong? I need a grouped bars in the chart diagram.
Thanks in advance.
Regards,
Shyam.
