How to get Breakdowns of Total

[#1]

Hi,

I have straight table in attached qvw. I need to show the break down of each Queue. I have Total Queue already created but I would need the Breakdowns which was showing in attached png.

could anyone help me by looking into attached please.

Thanks.

[rustyfishbones]

[#3]

when I am trying to drag nothing chamges for me please help please

[#4]

Thanks and when I am doing this it is showing blue line at vertical place not horizontal.do I need to change anything?

[#5]

Thanks and I can able to see Horizontal column but it is taking too long to appear. Could you let me know please how can I get individual percentages(%) which is showing in your screen shot.

[rustyfishbones]

Cant help till later, driving home

[Christian_Lauritzen]

Amelia,

How about the attached solution? I have Queue on the Y-axis and What on the x-axis. Changed to count HistoryID instead of ClientID as a client can make several calls. You could easily change back to ClientID again though. You also have the %-calculation.

Hope this helps.

Best regards,

Christian

[#8]

Hi Christian,

Thanks very much. I am getting values different when HistoryID is used as the vales are showing very ;arge compared when I use ClientID.Could I know how to calculate the exact values which are coming from access databaes? please help me. As it is showing different figures and exactly I would need to show how the Total breakdown into individual Queues along horizotal and vertical.

[Anonymous]

In the presentation tab you click the 'Partial Sum' checkbox on whichever expression you want to total.  You can also have it at the top/bottom or left/right by changing the Subtotals from top to bottom also on the presentation tab

[heimo_ernst_wei]

By selecting "Show Partial Sums" on "Chart Properties [Outcome] / Presentation"

But Attention in the Field "Dimensions and Expressions" "What" has to be selected first!

[#11]

Thanks. Actually I am getting values very large figures. how can I set this?