There are two sheets in the application.
First sheet tells about SAL,COMM,COMM/SAL,Cummulative SAL,Cummulative COMM,Cummulative COMM/Cummulative SAL (Cummulative %) .
Second sheet tells about distinct count of employees on GRADE wise (Percentage Grade).
Cumm % is 18.8% when I select 2015,Q2. But in sheet2 it is showing 2 records GRADE 10%-20% and 20%-30%. These two are Q1 and Q2 values. I want to show 10%-20% as Cumm % is 18.8%.
Please help me.
Create a Pivot or Straight Table
RangeSum(Above(Sum(Com CUmm),0,RowNo()))/SUM(TOTALCom CUmm)
Don't forget to change the 2nd expression to % Format using Number tab 🙂