Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using the below expression to get the cumulative in my pivot table .
and there one more expression similar to this.
Is there a way to get this expression written into the script and get a column in the front end ?
rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))
Can someone please explain me on this
Thanks in advance
Hey John, yeah, you just need to figure out what table you want that in and then add this to that part of the load scrip:
rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL))) as fieldname
If that is not what you meant, please provide some further detail on things, that may precipitate some others chiming in at that point too.
I just realized you may want that in a variable, syntax there would be:
LET variablename = rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))
Regards,
Brett