calcualted dimension on stack bar

[manoranjan_d]

key	amount	dept	passfail
key1	100	IT	PASS
key2	200	CSE	PASS
key3	300	EEE	PASS
key4	400	ECE	PASS
key5	500	COMP	PASS
key1	100	IT	PASS
key2	200	CSE	PASS
key3	300	EEE	PASS
key4	400	ECE	PASS
key5	500	COMP	FAIL
key1	100	IT	FAIL
key2	200	CSE	FAIL
key3	300	EEE	FAIL
key4	400	ECE	FAIL
key5	500	COMP	FAIL
key1	100	IT	FAIL
key2	200	CSE	FAIL
key3	300	EEE	FAIL
key4	400	ECE	FAIL
key5	500	COMP	FAIL

Hi above is my data.

In this I need to show bar chart for the dept for the FAIL ,in order to show the key count and amount .

so how to use the calculated dimension and for the dept for the FAIL and then the expression how to toggle between the record and dollar value

[sunny_talwar]

Check the attached

Expressions used:

1) =Count({<passfail = {'FAIL'}>} key)

2) =Sum({<passfail = {'FAIL'}>} amount)

When viewing count

When viewing Sum of amount