Filter From Given Period Time which Transaction availavle

[vijayit43]

In My Qv Dashboard when we give filter for '01 Apr 2014' to '30 Apr 2014' then show all item(because all items opening available on '01 Apr 2014') but we want to show only these item which transaction are available for given period time, for better clarification attached  QV given bellow please any body help .....

[#2 · Accepted solution]

Dear Vijay,

I used the follwing syntax for your ITEMNAME to get the desiered field:

Aggr(Only({<ITEMNAME=>}(ITEMNAME)),ITEMNAME)

Hope that works.

Regards

RL

[vijayit43]

Thanks Sir ............