I am trying to calculate the average sales amount of each group and this is subtracted from the latest bill amount. Like I showed below in the image,
I tried in many ways to get the answer but I got the wrong answers. I used the following expression.
Solved! Go to Solution.
Thank you for helping me with this
Yeah!! It's working good, how can I select the record (Amount) which is latest in Date and subtract it with your expression.
I have no idea how to pick it that record.
Yeah, Both Group and vDATE are in dimensions and I am trying to find latest sales made by each group is above their respective group average. Also, sample file is attached.