PIVOT CHART ISSUE

[#1]

I am trying ti accomplish the attached chart in Qlikview(Report.png) .  So far I was able to Get the Attached chart in the Pivot Table with First Dimension as (Claim Type Code) and Second one is a Calculated Dimension  (=ValueList('Sum','AVG') ).

The problem is that I cant get the Totals of every thing like in the Chart  (QV_Result.png)

Any suggestions.

[#2]

Is there a Way to show 'Sum' and 'AVG ' in the Total Also?

[agilos_mla]

Just below No, but you could try

- change total label with : ='Total                       SUM'&CHR(10)&'Total                       AVG'

Adjust the spaces between words to the size of the pivot.

Then please mark the answer as correct 😉

Michael