# Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Contributor

## Sum of Total Value

Hello All,

I have below Data (Department, Name and Value).

Expected Output -there should be another column which shows "Total Value" based on each department and when I collapse the group based on Department then it should show same value for column "Value" and "Total Value"

 Department Name Value Total Value a a1 1 6 a a2 2 6 a a3 3 6 b b1 4 15 b b2 5 15 b b3 6 15 c c1 7 24 c c2 8 24 c c3 9 24

After Collapsing table based on Department-

 Department Value Total Value a 6 6 b 15 15 c 24 24
Labels (1)
• ### SumofValue

1 Solution

Accepted Solutions
Highlighted
Contributor

## Re: Sum of Total Value

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder

Highlighted
Contributor

## Re: Sum of Total Value

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder

Community Browser