Thanks for this video. I have this project I'm working on that looks at attendance by Month, Year and Employee. I have created this let formula =LET(d,Data[ATTENDANCE DATE],e,Data[EMP NAME],p,Data[Position],m,Data[MONTHLY],i,Data[Include], sl,TRANSPOSE(SORT(UNIQUE(e),,-1)), vl,SORT(UNIQUE(d),,1), cl,SUM(m), fr,HSTACK("Start of Month",sl,"Total Payroll"), sr,HSTACK(vl,SUMIFS(m,d,vl,e,sl),SUMIFS(m,d,vl)), tr,HSTACK("Total Hours", SUMIFS(m,e,sl),SUM(cl)), VSTACK(fr,sr,tr)) I have a column in the Data set called Include =SUBTOTAL(3,[@[EMP NAME]]) Using the Pivotvy function it will filter the Data based on Slicers. The issue is that Pivotby is not available in the Customers current 365 Version. Theye do have the Filter and Let functions. How would i add the Filter function into the Let formula above.
Life changer for me thnx
Thanks for this video. I have this project I'm working on that looks at attendance by Month, Year and Employee. I have created this let formula
=LET(d,Data[ATTENDANCE DATE],e,Data[EMP NAME],p,Data[Position],m,Data[MONTHLY],i,Data[Include],
sl,TRANSPOSE(SORT(UNIQUE(e),,-1)),
vl,SORT(UNIQUE(d),,1), cl,SUM(m),
fr,HSTACK("Start of Month",sl,"Total Payroll"),
sr,HSTACK(vl,SUMIFS(m,d,vl,e,sl),SUMIFS(m,d,vl)),
tr,HSTACK("Total Hours",
SUMIFS(m,e,sl),SUM(cl)),
VSTACK(fr,sr,tr))
I have a column in the Data set called Include =SUBTOTAL(3,[@[EMP NAME]])
Using the Pivotvy function it will filter the Data based on Slicers. The issue is that Pivotby is not available in the Customers current 365 Version.
Theye do have the Filter and Let functions.
How would i add the Filter function into the Let formula above.
Thank you for this nice video 📹 👍
Thank you. 😀
The new Excel version= ? thanks
Thanks for the question. The function, LET, works in Excel 2021 and Excel 365. FILTER works in Excel 2021, 365, and 2019.
@@ExcelSmith thanks for your quick help
Fantastic
Thanks. I appreciate it.
Amazing
Thanks. 😀