No announcements
Found 4209 threads
-
0 VotesTurn off column subtotals but not row subtotals
Like if you have 4 years with months for columns, you can eliminate subtotals for individual years.Answered | 2 Replies | 758 Views | Created by AlexMartini - Friday, November 11, 2016 5:41 PM | Last reply by AlexMartini - Monday, November 14, 2016 11:58 PM
-
0 Votes
SubTotals in SSRS
Hi, There is a way to do this without Custom Code, use this as the expression for your subtotal textbox.Answered | 10 Replies | 3231 Views | Created by Sanam K M N - Friday, May 3, 2013 11:31 AM | Last reply by Sanam K M N - Tuesday, May 14, 2013 9:24 AM -
0 Votes
Subtotal in matrix
I need to show subtotals for field 1 but SSRS automatically calculated subtotal for field 2 as well.Answered | 3 Replies | 4325 Views | Created by Sam1980 - Thursday, January 6, 2011 5:01 PM | Last reply by Mohamed Irshad - Saturday, January 8, 2011 7:30 AM -
2 Votes
subtotal by month
If all the months are in the same year then the formula in thenew column would be =month(a2) you can then subtotal a month ...Answered | 3 Replies | 5559 Views | Created by Mikf - Thursday, July 14, 2011 4:04 PM | Last reply by G North - Thursday, July 14, 2011 4:19 PM -
0 Votes
Subtotal calculated expression from hidden detail row to subtotal row.
Hi donalejandro, According to your description, you want to make the detail rows toggled by the subtotal row, and when you hide detail rows the subtotal should get ...Answered | 1 Replies | 830 Views | Created by donalejandro - Monday, May 23, 2016 5:57 AM | Last reply by Xi Jin - Tuesday, May 24, 2016 7:42 AM -
1 Votes
Cascading subtotals
I've been reading this site http://www.powerpivotpro.com/2011/09/profit-lossthe-art-of-the-cascading-subtotal/ about cascading subtotals.Answered | 1 Replies | 931 Views | Created by AlexMartini - Friday, November 4, 2016 9:41 PM | Last reply by Angelia Zhang - Tuesday, November 8, 2016 7:52 AM -
3 Votes
Subtotals - sum of average column
Hi Charles, Subtotals in Power Pivot actually have the same "behavior" as subtotals in normal Pivot tables.Answered | 3 Replies | 3492 Views | Created by Charles__Toray - Tuesday, June 17, 2014 3:44 PM | Last reply by Charles__Toray - Wednesday, June 18, 2014 10:15 AM -
0 Votes
SUBTOTAL AUTOMATION
I created the following formula : =if(a2=1(subtotal(9,a1))) But, it does n't work.Answered | 9 Replies | 1674 Views | Created by rjagathe - Saturday, October 6, 2012 12:03 PM | Last reply by rjagathe - Friday, October 12, 2012 3:57 PM -
0 Votes
Average of multiple group subtotals
I would try creating 1. a function in the report.Code section (right click in the report designer and click report properties, then code tab)Every time you call it, it will record ...Answered | 2 Replies | 896 Views | Created by Franco Lopes - Saturday, December 5, 2015 4:38 PM | Last reply by Visakh16 - Sunday, December 6, 2015 6:31 AM -
0 Votes
expressions based on subtotals
Thanks for the feedback, I'll give it a try I'm actually trying to create report to emulate growth over period(OLAP) for an Informix datasource I want to see the ...Answered | 5 Replies | 5844 Views | Created by jackAttack375 - Monday, April 23, 2007 8:02 PM | Last reply by Manmohan_Raja - Tuesday, August 16, 2011 11:13 AM -
0 Votes
Named Set Subtotal for Excel
Unfortunately, when that set is used in excel, it does not return a subtotal which is expected behavior.Answered | 1 Replies | 5472 Views | Created by Ludis - Friday, October 8, 2010 9:55 PM | Last reply by Mark Wojciechowicz - Monday, October 11, 2010 1:09 AM -
0 Votes
Subtotals In Reporting Services
If you create a group within the report, SSRS automatically adds subtotals for the groups.Answered | 5 Replies | 17497 Views | Created by muzzettemm1 - Wednesday, June 10, 2009 7:23 PM | Last reply by Raymond-Lee - Tuesday, June 16, 2009 6:01 AM -
0 Votes
Don't show subtotal values
Turning subtotals off in Excel is faster, because IF(HASONEVALUE(..)) doesn't have to be evaluated for each cell in the pivot table.Answered | 1 Replies | 719 Views | Created by AlexMartini - Tuesday, August 23, 2016 7:55 PM | Last reply by Michiel Rozema - NL - Wednesday, August 24, 2016 11:35 AM -
0 Votes
Adding subtotal to a field in tablix
This is my current matrix, and I want it to subtotal all the markets, just like it does in my data image below.Answered | 4 Replies | 858 Views | Created by Antonio Spano - Tuesday, December 8, 2015 10:27 PM | Last reply by Antonio Spano - Wednesday, December 16, 2015 2:09 PM -
0 Votes
Hide subtotal for a child group in tablix
While when we click the (+) sign on the Department_Name, we can see the subtotal.Answered | 4 Replies | 3126 Views | Created by Sam1980 - Thursday, September 26, 2013 3:43 PM | Last reply by Katherine Xiong - Tuesday, October 1, 2013 4:23 AM -
0 Votes
Matrix Subtotal Conditional
It's so simple that I can't believe it's this difficult to only show a subtotal line when there is more than one companyname!Answered | 7 Replies | 6018 Views | Created by lisalovecad - Tuesday, August 23, 2011 8:05 PM | Last reply by Lola Wang - Friday, August 26, 2011 1:50 AM -
0 Votes
Power BI - Subtotals for Financial Reports
I am putting together a Power BI dashboard with very specialized subtotals for specific groups, I am using a Matrix Visualization for this report, but have struggled with placing my ...Answered | 1 Replies | 1602 Views | Created by Power BI User - Tuesday, December 8, 2020 10:04 PM | Last reply by Dave Patrick - Tuesday, December 8, 2020 10:55 PM -
0 Votes
How to add a subtotal
Hi Antonio, According to your description, you want to add a subtotal for each Master_Market instance, right?Answered | 2 Replies | 1557 Views | Created by Antonio Spano - Tuesday, December 29, 2015 6:20 PM | Last reply by Qiuyun Yu - Wednesday, December 30, 2015 2:32 AM -
0 Votes
RDLC Matrix Subtotal
The subtotal can work in 2005 or 2008.Answered | 1 Replies | 7596 Views | Created by Deba_Diamond - Saturday, October 10, 2009 2:19 PM | Last reply by Jerry Nee - Tuesday, October 13, 2009 2:43 AM -
2 Votes
Subtotals by Group
For the first 3 groups I manually entered subtotal calculations based on the group (e.g.Answered | 2 Replies | 2176 Views | Created by Bonediggler - Friday, October 12, 2012 9:14 PM | Last reply by Bonediggler - Monday, October 15, 2012 7:17 PM - Items 1 to 20 of 4209 Next ›
No announcements
