- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 Expressions in Pivot Chart
I'm showing the count of defects (state-wise) and I'm showing them horizontally. I want to add one more column which will show me the total count of defects.
For example, in CR4594 Lion, I'm able to see the count of defects which are fixed(2), open(5)....submitted(11). I also want to see the total count of defects for CR4594 which should be 2+5+10+4+11= 32.
Is there any way to have the 2nd expression NOT split state-wise? I hope I have made my requirement clear.
Thanks,
YASH
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Just try to add the total for the State level.
Go to Properties -> Presentation Tab-> Select State -> Check the box "Partial Sums" -> Click OK.
Regards,
Kaushik Solanki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Yash,
UHave you tried to use set analysis? Something like: Count({<Status>} Defects)
Above you donot take into account selections in Status field.
Regards,
H
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Just try to add the total for the State level.
Go to Properties -> Presentation Tab-> Select State -> Check the box "Partial Sums" -> Click OK.
Regards,
Kaushik Solanki