Hi All
From HIC blog have show us the inclusive % using below expression :-
RangeSum(Above(Sum(sales), 0, RowNo())) / Sum(total sales)
I need to replace with , because if using row , it will not allow me sort sales col from hi to lo:-
Sum(sales)/Sum(TOTAL(sales))
For Exclusive % using below expression :-
RangeSum(Above(Sum(sales), 1, RowNo())) / Sum(total sales)
I like to ask , how to replace the above with out using row ?
Paul