Is there any way to do this grouping?

[JohnIssue]

Let say I have one Category and one Subcategory, with values of a measure for each subcategory. I have a simple table, example:

Category   Subcategory   Measure

A                          A_1                  1

A                         A_2                   3

B                         B_1                   2

Can I add a measure that for each row shows the total of the sum of this measure for each category? In the previous example it would be: 

Category   Subcategory   Measure    Sum_Measure_Category

A                          A_1                  1                            4

A                         A_2                   3                             4

B                         B_1                   2                            2

[vinieme12]

use the TOTAL keyword

Sum_Measure_Category   =  sum(TOTAL <Category> Measure)

[vinieme12 · Accepted solution]

Refer this blog for more

https://community.qlik.com/t5/Design/What-does-the-TOTAL-qualifier-do/ba-p/1472990

[JohnIssue]

Thank you for your response! It works, but it seems like it is necessary that the dimension 'Category' is shown in the table. Is it possible to achieve this without showing this dimension?

Thanks in advance!

[vinieme12]

try below

=sum(total <Subcategory> aggr(noDistinct sum( Measure) , Category))