Chart calculation at two levels

[jagjivvt]

Hi, i am trying to show values in a single chart without the 2nd value repeating in the AP Value expression. see attached example.

Vendor     Employee     Employee Value     Vendor Value

A               1                    10                      

A               2                    5    

A               3                    8

Total A                                23                                       25

B               4                    8                   

B               5                    5                             

B               6                    6              

Total B                           19                                            20

Total                              42                                             45

when i create this in Qlik it shows the vendor value in each row and i need the chart to show as above.

thanks

[Gysbert_Wassenaar · Accepted solution]

See attached example. Is that what you need?

[jagjivvt]

Thanks, works brilliantly and will be using this in may charts for the future.