Author Topic: Percentage calculation in Cross tab report  (Read 307 times)

Offline rajua99

  • Full Member
  • ***
  • Join Date: Jun 2009
  • Posts: 40
  • Forum Citizenship: +0/-0
Percentage calculation in Cross tab report
« 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

Offline Francis aka khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 543
  • Forum Citizenship: +26/-4
    • CognosM
Re: Percentage calculation in Cross tab report
« Reply #1 on: 19 Feb 2020 09:03:21 am »
are you using relational or dimensional report?

 



       
Twittear