need a column with sums of category

[Hikmet_JCI]

Hello

I dont get any further
need a column with sums of category

Danke

[Hikmet_JCI]

Hi..

thanks

I would like to use the new column as a sliding filter and should accept other filters

??

[Ashish_Mathur]

Hi,

Write this calculated column formula

Sum = calculate(sum(data[un]),filter(data,data[cat]=earlier(data[cat])))

Hope this helps.

[Hikmet_JCI]

Hi..

thanks

I would like to use the new column as a sliding filter and should accept other filters

[Ashish_Mathur]

Hi,

Since mine is a calculated column solution, you will be able to use that calculated column in a filter.

[bcdobbs · Accepted solution]

Hi,
Worked solution with this as a calculated column is here:

Example 

However you can also just drop the cat column straight into the rows of a matrix and the un column into the Values: