Sum of Latest Values in Week, in Pivot Table

[BartVA]

I have a data table in the following format, see attached csv for an export (of randomized data).

These concern End Balances, by day/company/journal/currency, of bank accounts.

I need to show in a pivot, with YearWeek in the rows, and currency_id in the columns, the total balance_end_real for that week.

So I need to 1) take all the balance_end_real's of the LastDateInWeek (Date=LastDateInWeek) and 2) sum these by currency.

If needed, I need to be able to filter by company_id and journal_id, and/or add these as row levels to the pivot.

I tried 
sum(AGGR(FirstSortedValue(balance_end_real), -YearWeek, company_id, journal_id, currency_id))
and
Sum(Aggr( If(date = LatestDateInWeek, balance_end_real), YearWeek ))
but both give all zero values.

[Anil_Babu_Samineni]

@BartVA When I flag the dates, I see nothing that is match. Could be the reason that you have zero.

[BartVA]

Hi, thanks for looking into my question!

I made a few changes and now have Dates that are equal to Last Dates. See also stored table in attachment.

(Formula is: If(date = LatestDateInWeek, 1, 0) as DateIsLatestDateInWeek;)

Still, pivot shows zero's only.