Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I wanna make a expression in a Pivot Table, where there is only one dimension, Date.
The expression is a division between the balance today and the total balance 2 months ago.
The field Date is for any date, and Date_2 is a date 2 month before Date.
This is the expresion made:
sum(Aggr(sum( {<cod_Situation = {3} >} BuvBalance), Date))/
sum(Aggr(sum( {<cod_Situation = {1, 2, 3, 4, 5, 6, 7, 8, 9} >} BuvBalance), Date_2))
The problem is that the expression can not evaluate correctly Date_2, and the dividend does not work correctly.
In fact, looks like it evaluate Date_2 as Date.
Thanks for any help!
Ok, si funcionó, marcá el post como respondido, así se cierra.