how to sum values from a date that also did have values for another date

[Alfovic]

Hi everyone,

i´d like to know if it is possible if you have a table with a column for :

• dates
• categories
• values

could you sum the values as of an specific date and category where also those values for those categories also existed for another specific date?

for example: sum all values of categories "C" as of "01-05-2019" that existed by "01-04-2019"?

any help would be greatly appreciated!

[Channa]

=Aggr(Sum(Value),Category,Date)

[Alfovic]

Thanks Channa,
tried "sum(aggr(sum({<date= {"$(vMaxDate)"}>}value), category,date))"
but got the sum of the max date for all categories

[Channa]

you can work with P()

it will help with Categories exist only max date

try the P() and E()