COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rajua99 on 13 Feb 2020 04:18:54 PM

Title: Percentage calculation in Cross tab report
Post by: rajua99 on 13 Feb 2020 04:18:54 PM
Hello,

I  created a cross tab report and i want to add another column in the measure to calculate percentage for each month in the Cross tab.

I am attaching the cross tab report out put that i am trying to generate. I was able to get the count of employee transaction that they processed in the month. next to that month i would like to calculate percentage of transaction each employee is generated in that month.

I need help with that formula to calculate percentage in the cross tab report.

Thanks
Raju
Title: Re: Percentage calculation in Cross tab report
Post by: Francis aka khayman on 19 Feb 2020 09:03:21 AM
are you using relational or dimensional report?