Displaying current YTD value

[wossenhh]

Hi, I have a problem showing the current value. Here is my question. Every month I am loading a payroll file for employee and with some calculation to show the Max value of employee’s on dashboard. As you can see below the base rate of employee A is 100 and for Jan, Feb, Mar there was no problem the Max YTD value shows correctly. The problem happened on April for some reason, Employee A reduced some amount (in this case $150.00) and shown as 250. So for April report QV shows, the Max value as 300 which is correct, however, I want to see the current value which is 250 for April. I was suggested to use Last Value function, and it didn’t work. Any help please?

Employee      YTD Earning      Month

A                100                           Jan

A                200                           Feb

A                300                           Mar

A                250                           Apr         

Thanks,

Wossen

[wossenhh]

Hi Manish,

I hope you meant reversed when you say reserved. This was happened just for this month, and the money has reversed from employee A. Does this might happen in the future? who knows it might....but I am sure there will be a trick to reflect the amount in QV.

[#3]

not sure what exactly your data looks like, assuming its same as you provided sample and your chart is with dimension employee and expression as latest salary

exp: max({<Month={"$(=Date(max(Date#(Month,'MMM')),'MMM'))"}>}[YTD Earning])

[wossenhh]

Thanks My QV - the dimension I have is Fiscal month and some calculated dimensions just to get department, employee so on. I tried what you suggested and no luck.