I am new and I browsed through trying to find the answer but got no
luck. Everyone here says that to get a subtotal of a group just right
click on the group and get the subtotal. I tried so many times but
still can not find out how to do it. Where can i get subtotal of a
column?
thanks a lot.Cheers,
I am assuming you are using a matrix. Right click on the textbox that
you want to subtotal on and there should be an option for it (called
'Subtotal')...click on that and presto...it does it for you. Hope that
helps!
if you are not using a matrix, let me know and i will hopefully give
you correct direction on that or find some tech artical for you.
Thanks and have a great day, Kerrie
cheers...@.hotmail.com wrote:
> I am new and I browsed through trying to find the answer but got no
> luck. Everyone here says that to get a subtotal of a group just right
> click on the group and get the subtotal. I tried so many times but
> still can not find out how to do it. Where can i get subtotal of a
> column?
> thanks a lot.|||Hi Kerrie,
No i am working on a table, there is one column I need to get the
subtotal on. It is not a matrix, do you have any clue on tables?
thanks
Cheers
Kerrie wrote:
> Cheers,
> I am assuming you are using a matrix. Right click on the textbox that
> you want to subtotal on and there should be an option for it (called
> 'Subtotal')...click on that and presto...it does it for you. Hope that
> helps!
> if you are not using a matrix, let me know and i will hopefully give
> you correct direction on that or find some tech artical for you.
> Thanks and have a great day, Kerrie
>
> cheers...@.hotmail.com wrote:
> > I am new and I browsed through trying to find the answer but got no
> > luck. Everyone here says that to get a subtotal of a group just right
> > click on the group and get the subtotal. I tried so many times but
> > still can not find out how to do it. Where can i get subtotal of a
> > column?
> >
> > thanks a lot.|||You can copy that field and put it in the table footer or group footer.
then put sum in front of it. It will look like this. sum(field). Thats
it.
<cheers_ye@.hotmail.com> wrote in message
news:1156792934.941494.202400@.m73g2000cwd.googlegroups.com...
> Hi Kerrie,
> No i am working on a table, there is one column I need to get the
> subtotal on. It is not a matrix, do you have any clue on tables?
> thanks
> Cheers
>
> Kerrie wrote:
>> Cheers,
>> I am assuming you are using a matrix. Right click on the textbox that
>> you want to subtotal on and there should be an option for it (called
>> 'Subtotal')...click on that and presto...it does it for you. Hope that
>> helps!
>> if you are not using a matrix, let me know and i will hopefully give
>> you correct direction on that or find some tech artical for you.
>> Thanks and have a great day, Kerrie
>>
>> cheers...@.hotmail.com wrote:
>> > I am new and I browsed through trying to find the answer but got no
>> > luck. Everyone here says that to get a subtotal of a group just right
>> > click on the group and get the subtotal. I tried so many times but
>> > still can not find out how to do it. Where can i get subtotal of a
>> > column?
>> >
>> > thanks a lot.
>|||On that, you would use your group footer for the subtotals...
ReportHeader....column headings (optional)
Group1Header...data (EX. Departments to your work)
Group2Header...data (EX. People in that dept. from Grp1Hdr)
GroupDetail......data (EX. Dates and Hours that each person worked
from Grp2Hdr)
Group2Footer....data (EX. The SUM(Hours) for that each person worked
from Grp2Hdr)
Group1Footer....data (EX. The Sum(Hours) for that each person worked
from Grp2Hdr in that Department Grp1Hdr)
ReportFooter.....data (EX. The SUM(Hours) for the hole report)
I hope this makes since, if not let me know and I will try to explain
it another way.
Thanks, Kerrie
cheers...@.hotmail.com wrote:
> Hi Kerrie,
> No i am working on a table, there is one column I need to get the
> subtotal on. It is not a matrix, do you have any clue on tables?
> thanks
> Cheers
>
> Kerrie wrote:
> > Cheers,
> >
> > I am assuming you are using a matrix. Right click on the textbox that
> > you want to subtotal on and there should be an option for it (called
> > 'Subtotal')...click on that and presto...it does it for you. Hope that
> > helps!
> >
> > if you are not using a matrix, let me know and i will hopefully give
> > you correct direction on that or find some tech artical for you.
> >
> > Thanks and have a great day, Kerrie
> >
> >
> >
> > cheers...@.hotmail.com wrote:
> > > I am new and I browsed through trying to find the answer but got no
> > > luck. Everyone here says that to get a subtotal of a group just right
> > > click on the group and get the subtotal. I tried so many times but
> > > still can not find out how to do it. Where can i get subtotal of a
> > > column?
> > >
> > > thanks a lot.|||Great, it works!!!!!!!!
so guys, keep in mind, in the future don't use expression like
= sum(field!*****, 'datatset1') for a group subtotal
use this instead --> = sum(field!*****)
hope everyone get it. It is that simple (don't let it waste more of
your time)
Have a good afternoon,
cheers
Ben Watts wrote:
> You can copy that field and put it in the table footer or group footer.
> then put sum in front of it. It will look like this. sum(field). Thats
> it.
> <cheers_ye@.hotmail.com> wrote in message
> news:1156792934.941494.202400@.m73g2000cwd.googlegroups.com...
> > Hi Kerrie,
> >
> > No i am working on a table, there is one column I need to get the
> > subtotal on. It is not a matrix, do you have any clue on tables?
> >
> > thanks
> > Cheers
> >
> >
> > Kerrie wrote:
> >> Cheers,
> >>
> >> I am assuming you are using a matrix. Right click on the textbox that
> >> you want to subtotal on and there should be an option for it (called
> >> 'Subtotal')...click on that and presto...it does it for you. Hope that
> >> helps!
> >>
> >> if you are not using a matrix, let me know and i will hopefully give
> >> you correct direction on that or find some tech artical for you.
> >>
> >> Thanks and have a great day, Kerrie
> >>
> >>
> >>
> >> cheers...@.hotmail.com wrote:
> >> > I am new and I browsed through trying to find the answer but got no
> >> > luck. Everyone here says that to get a subtotal of a group just right
> >> > click on the group and get the subtotal. I tried so many times but
> >> > still can not find out how to do it. Where can i get subtotal of a
> >> > column?
> >> >
> >> > thanks a lot.
> >sql
Showing posts with label subtotal. Show all posts
Showing posts with label subtotal. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
How to get the matrix row subtotal value
Hi,
i created a report like this:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 100%
i wana show the percentage, so i need to get the row subTotal value, can
anyone help me?
--
Pony TsuiHi Pony,
Thank you for your posting!
Based on my understanding, you want to know how to get the row sub Total
value. If I misunderstood your concern, please feel free to let me know.
You could add the subTotal to your row group. Just right-click the Group
and click SubTotal, then, you could use get the Subtotal under the detail
row.
Hope this will be helpful and if you have any questions or concerns, please
feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Wei,
Thanks for your reply!
I know how to add the subTotal field, i want to get the row subtotal value to
compute the percentage in each cells
as the sample:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 100%
sales2 customer2 10 20 30 40 100
10% 20% 30% 40% 100%
i need to get subtotal 100 in the Q1 - Q4 Columns, i already found out i can
type:
Sum(Fields!Amount.Value, "matrix1_Customer")) to get the row subtotal value,
i can get percentage of Q1-Q4, but in subtotal, the percentage will not 100%,
it show the percentage of (rowsubtotal / total), so how to fix this problem?
Pony Tsui|||Hi Wei,
As i wrote in my previous mail, the percentage of subtotal field will show
the rowSubTotal / Total, i wanna get the resule:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 100%
sales2 customer2 10 20 30 40 100
10% 20% 30% 40% 100%
but the report show:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 50%
sales2 customer2 10 20 30 40 100
10% 20% 30% 40% 50%
How to fix this problem?
Pony Tsui|||Hi Pony,
Thanks for the reply.
Would you please send your report file to me? Also, please send some sample
data so that I can troubleshoot and re-produce your problem. Thank you!
I understand the information may be sensitive to you, my direct email
address is weilu@.ONLINE.microsoft.com(Please remove ONLINE when you send
the email), you may send the file to me directly and I will keep it secure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Pony,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
i created a report like this:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 100%
i wana show the percentage, so i need to get the row subTotal value, can
anyone help me?
--
Pony TsuiHi Pony,
Thank you for your posting!
Based on my understanding, you want to know how to get the row sub Total
value. If I misunderstood your concern, please feel free to let me know.
You could add the subTotal to your row group. Just right-click the Group
and click SubTotal, then, you could use get the Subtotal under the detail
row.
Hope this will be helpful and if you have any questions or concerns, please
feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Wei,
Thanks for your reply!
I know how to add the subTotal field, i want to get the row subtotal value to
compute the percentage in each cells
as the sample:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 100%
sales2 customer2 10 20 30 40 100
10% 20% 30% 40% 100%
i need to get subtotal 100 in the Q1 - Q4 Columns, i already found out i can
type:
Sum(Fields!Amount.Value, "matrix1_Customer")) to get the row subtotal value,
i can get percentage of Q1-Q4, but in subtotal, the percentage will not 100%,
it show the percentage of (rowsubtotal / total), so how to fix this problem?
Pony Tsui|||Hi Wei,
As i wrote in my previous mail, the percentage of subtotal field will show
the rowSubTotal / Total, i wanna get the resule:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 100%
sales2 customer2 10 20 30 40 100
10% 20% 30% 40% 100%
but the report show:
Q1 Q2 Q3 Q4 subTotal
sales1 customer1 10 20 30 40 100
10% 20% 30% 40% 50%
sales2 customer2 10 20 30 40 100
10% 20% 30% 40% 50%
How to fix this problem?
Pony Tsui|||Hi Pony,
Thanks for the reply.
Would you please send your report file to me? Also, please send some sample
data so that I can troubleshoot and re-produce your problem. Thank you!
I understand the information may be sensitive to you, my direct email
address is weilu@.ONLINE.microsoft.com(Please remove ONLINE when you send
the email), you may send the file to me directly and I will keep it secure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Pony,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)