Mavericks334
Active Member
- Joined
- Jan 26, 2011
- Messages
- 280
Hi,
I am able to project the total sales for the year using TOTAL YTD and Year FRAC combined.
However from the same data if i try to project the total sales for individual person it does not work? I have tried using filter as well and does not seem to work?
Below is the measure for the entire unit:
=TOTALYTD(SUM(MDS_YTD[USD Amount]),MDS_YTD[Related_Date],ALL(MDS_YTD))/YEARFRAC(CONCATENATE("26/12/",YEAR([Related_Date])-1),[Related_Date])
How do i modify the above measure to get it for an individual person.
Regards,
Ren.
I am able to project the total sales for the year using TOTAL YTD and Year FRAC combined.
However from the same data if i try to project the total sales for individual person it does not work? I have tried using filter as well and does not seem to work?
Below is the measure for the entire unit:
=TOTALYTD(SUM(MDS_YTD[USD Amount]),MDS_YTD[Related_Date],ALL(MDS_YTD))/YEARFRAC(CONCATENATE("26/12/",YEAR([Related_Date])-1),[Related_Date])
How do i modify the above measure to get it for an individual person.
Regards,
Ren.