Hello,
In my report i have need display Revenue and Expenses and i need to apply Group by for revenue and expenses.
I need to calculate the percentage for each Revenue and Expenses with the Total Revenue.
Because of Group by the percentage for Expenses is always empty. Is there any function in Cognos Report Studio to ignore Group Up and calculate percentage for each expense and display next to it..
I am attaching a screen shot for Example...
Thanks,
Raju
Not sure you got your answer as I just went through something similar
[Revenue Labor]/ total([Total Revenue] for report)
[Revenue Labor Other]/ total([Total Revenue] for report)
etc
hth