I need help creating a calculated field to mirror what I have wrote in Excel.
If you look at row 1133, you will see that I have a SUMProduct calculation (e.g. =SUMPRODUCT(--($B$2:$B$1131>=EOMONTH(M$1,-1)+1)*--($B$2:$B$1131<=M$1)*--($A$2:$A$1131<>"Nullify"),($G$2:$G$1131))
Any and all help is much appreciated!
Please attach your excel sheet where you did this.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...