February 25, 2010 at 5:04 pm
Month-YearNO- PEAK TIMEYES-PEAK TIMETotal Percent Peak, Non PeakPercent
Jan 2009246,432.00225,828.00472,260.00XX XX
Feb 2009622,291.00556,975.001,179,266.00XX XX
Mar 2009734,114.00655,259.001,389,373.00
Apr 2009667,796.00624,030.001,291,826.00
May 2009792,739.00667,328.001,460,067.00
I have this Matirx, I want to add percentage of peak and non peak at the end(XX). I am grouping by Yes and NO peak. How do i get values for Peak/No Peak and caluclate a percentage in the end. Please some one help!
group on [PeakTimeY_N].
February 26, 2010 at 7:08 pm
I believe if you take a look at this article it should help you out in resolving this:
Advanced Matrix Reporting Techniques[/url]
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply