An interesting scenario

[#1]

I have the data like this. Employee id, their home location and work location

Employee Home Work

101               A            B

102              A             C

103              A             A

104              C             B

105               C            C

106               B            A

I need a graph like this. Is this possible?

Work    WorkCount   HomeCount

A              2                         3

B              2                         1

C             2                           2

[#2]

Sorry Kumar, this didn't work

[qlikpahadi07]

let me know if that was helpful

[kumarnatarajan]

Hi Ram,

PFA. It's working fine