I know you want an extra column. The reason I'm asking WHY you want an AVERAGE is because in the context of your sample, an average makes no sense. Can you try and explain what the AVERAGE must be, then we can help.
On Thu, Nov 25, 2010 at 10:12 AM, Rafeeq . <[email protected]> wrote: > I just need a additional column like we have sub total, that contains the > percentage, the data is below is just sample, how i want the report.. any > help is appreciable. > > Thanks, > Rafeeq > > > On Thu, Nov 25, 2010 at 3:32 PM, Jamie Fraser <[email protected]>wrote: > >> An average of what? >> >> >> On Thu, Nov 25, 2010 at 7:26 AM, Rafeeq . <[email protected]> wrote: >> >>> Hello, >>> >>> Can any help me with SSRS 2005, I want to have a report like below >>> >>> >>> >>> Male >>> >>> Female >>> >>> Total >>> >>> Average >>> >>> License 1 >>> >>> 10 >>> >>> 20 >>> >>> 30 >>> >>> avg >>> >>> License 2 >>> >>> 10 >>> >>> 20 >>> >>> 30 >>> >>> avg >>> >>> License 3 >>> >>> 10 >>> >>> 20 >>> >>> 30 >>> >>> avg >>> >>> License 4 >>> >>> 10 >>> >>> 20 >>> >>> 30 >>> >>> avg >>> >>> License 5 >>> >>> 10 >>> >>> 20 >>> >>> 30 >>> >>> avg >>> >>> License 6 >>> >>> 10 >>> >>> 20 >>> >>> 30 >>> >>> avg >>> >>> >>> The yellow lines are coming from Database Total is SUBTOTAL and how to >>> add one more avg column. >>> -- >>> With Warm Regards, >>> Rafeeq >>> >>> >>> >> > > > >
