Pivot Chart with Balance for the last date in each period

[robinsond31]

I need to create a chart that will show the balance for the last date in each period. I have attached a file with the sample data and the results I am looking for. I was able to use the AGGR funtion to create a calculated dimension for the date, but I can't figure out how to get the value associated with that date.

[lironbaram · Accepted solution]

hi 

you can use 

firstsortedvalue(Balance,-Date)

[robinsond31]

That worked. Thanks.

[lironbaram]

hi 

always happy to help 

please mark the answer as correct , so other user will now they can help someone else