Forum Discussion
Filter for cumulative total
Hi All, I would like to conditionally summarize categories where we had data until now in the year. For example: 1th month we had value1 only for cat2, so the result ...
tamerj1
Community Champion
Community ChampionPlease provide more details. What are value1 and value2? Columns or measures? How do you come to the results 20 and 30?
Value1 and Value2 are both columns in the table.
Value1 should be in the filter criteria and I have to check whether it has value until this year or not. Maybe I should count with it as running total in an extra calculated column.
Value2 is the value what I would like to summarize, depending on which month is selected and value1 values until now for that category.
If Value1 "activates" a category then the Value2 for that category must be included in the total, otherwise not.
