2 Expressions in Pivot Chart

[yashcena]

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

[hector_munoz]

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

[kaushiknsolanki · Accepted solution]

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