Analytics Software

Hello guys

I have a report that has several columns about sales call type and call counts

It looks like this:

Calls Type Call Counts

Missed 200

Handled 3000000

Rejected 40000

Dropped 50000

Now I wanna create a report that look like this:

Missed call counts Handled Call counts Rejected Counts Drop counts Other Columns

200 300000000 40000 50000 Data

So that I can perform other calculations on the difference and comparison of handled calls counts vs other call counts..

I know pivot table view can make the report look like in such way, but they cant do further calculations on that..

So I need to create new solid columns that capture call counts based on call types..

How would I be able to do that on Answers? I don't have access to the RPD, so is it possible to do it sololy on answers? Or should I just ask ETL support on this?

Any pointers will be deeply appreciated!

Thank you