No announcements
Found 2501731 threads
-
0 VotesPercentage of Row Total Calculation
I got my measure to work: [Previous YR] / CALCULATE( SUM( sales[amt]) , DATESBETWEEN(DimDate[dateKey], DATE(2012,01,01), ...Answered | 2 Replies | 3159 Views | Created by John Newbie604 - Wednesday, January 23, 2013 7:19 PM | Last reply by Elvis Long - Friday, January 25, 2013 6:38 AM
-
1 Votes
Calculation percent for given value in each row on total row.
I just wonder if we use UNION ALL statement , will it cause performance problem in big data.Answered | 3 Replies | 1328 Views | Created by Aye Aye - Thursday, March 14, 2013 5:42 AM | Last reply by Uri Dimant - Friday, March 15, 2013 3:49 AM -
0 Votes
Percentage by ROW in SSRS
In Design surface, insert a matrix tablix, use field[cat] as parent row group, use field[T_Date] as child row group, use filed[mnth] as column group.Answered | 3 Replies | 767 Views | Created by GSKR - Saturday, September 24, 2016 6:46 AM | Last reply by Yuliana Gu - Thursday, September 29, 2016 3:56 AM -
0 Votes
Stuck in Grouping Column and Row wise
Sales ...Answered | 1 Replies | 5319 Views | Created by RameshSahu - Saturday, August 21, 2010 1:03 PM | Last reply by Mohamed Irshad - Saturday, August 21, 2010 7:58 PM -
1 Votes
Calculate percentage
There is not any setting of percentage.Answered | 3 Replies | 2990 Views | Created by sqlakm - Monday, May 27, 2013 7:12 AM | Last reply by Charlie Liao - Tuesday, May 28, 2013 6:25 AM -
0 Votes
row wise total in SSRS 2005 Matrix report
This will add one more column next to last column.Answered | 8 Replies | 9502 Views | Created by Peter's - Sunday, June 12, 2011 5:11 AM | Last reply by Elvis Long - Saturday, June 18, 2011 5:36 AM -
3 Votes
How to calculate a percentage in a Matrix row SSRS
ClaimCount.Value, "Answered | 4 Replies | 9396 Views | Created by Andrevw23 - Friday, January 17, 2014 8:16 AM | Last reply by Andrevw23 - Monday, January 20, 2014 6:13 AM -
0 Votes
How to SUM Group wise Percentage values in the ssrs
Finally, on your total percentage, enter the expression =Code.get_total_pct() Sorry I dont have time to double check the code, but you get the idea.Answered | 6 Replies | 6568 Views | Created by John.Eddie - Wednesday, January 9, 2013 1:11 PM | Last reply by krootz - Monday, January 14, 2013 1:08 PM -
0 Votes
percentage calculation
Hi that does work, just to go one step further what would the syntax be to only bring back records which had a percentage greater than 50%?Answered | 9 Replies | 7694 Views | Created by aivoryuk - Saturday, February 19, 2011 2:54 PM | Last reply by aivoryuk - Sunday, February 20, 2011 10:28 AM -
0 Votes
Count Rows using Calculated Field
YOu can not use Aggreate function in Dataset Calculated Field.Answered | 3 Replies | 10885 Views | Created by CBlasek - Monday, February 1, 2010 7:58 PM | Last reply by MSBIProgrammer - Tuesday, February 2, 2010 4:11 PM -
3 Votes
PowerPivot formula for row wise weighted average
Hi Reza, According to your description, you need to calculated the average value of Vel group on Count and Hour, right?Answered | 2 Replies | 2669 Views | Created by Reza Hasanzadeh - Wednesday, April 22, 2015 6:39 AM | Last reply by Reza Hasanzadeh - Saturday, April 25, 2015 8:10 AM -
6 Votes
Calculating Percentages
The spool table will have less than or equal rows than the base table, based on the number of rows per group.Answered | 13 Replies | 3628 Views | Created by Herline - Tuesday, June 29, 2010 3:35 PM | Last reply by Herline - Tuesday, June 29, 2010 7:07 PM -
0 Votes
How to calculate % of each year when there are breakdowns on the rows
It returns Country percentage of each year.Answered | 2 Replies | 654 Views | Created by AlexMartini - Sunday, September 18, 2016 11:13 AM | Last reply by Angelia Zhang - Monday, September 19, 2016 8:43 AM -
0 Votes
measure showing both value and percentage of row
If this is just an MDX statement then you could create a calculated member with member [Measures].Answered | 3 Replies | 4460 Views | Created by city_ash - Friday, April 9, 2010 2:09 AM | Last reply by city_ash - Friday, April 16, 2010 1:28 AM -
0 Votes
Sheet row for a given text
Y a h y a, if you want to find the text have multiple occurrences and want to find row number for each occurrence then you can use the code mentioned below.Answered | 2 Replies | 303 Views | Created by Y a h y a - Thursday, January 5, 2017 3:33 AM | Last reply by Deepak Saradkumar Panchal - Friday, January 6, 2017 2:20 AM -
1 Votes
Percentage Calculated member
Hi Balaji, Need some more information - 1- whether you are going to browse cube with all four dimension or Just by one by one ...Answered | 3 Replies | 3360 Views | Created by Balaji Prasad - Tuesday, March 31, 2015 1:56 PM | Last reply by Suhas Kudekar - Tuesday, April 7, 2015 2:13 PM -
0 Votes
Calculating the remaining percentage
To add column or row, we could use Range.EntireColumn property or Range.EntrieRow property.Answered | 1 Replies | 593 Views | Created by winoa - Thursday, November 19, 2015 5:20 AM | Last reply by Starian chen - Friday, November 20, 2015 6:30 AM -
1 Votes
calculate percentage of amount between datagridview and textbox
means if total amount is 300 is in the textbox1 then: distribution to agents: textbox1.value * DGV column "percentage" ...Answered | 9 Replies | 1367 Views | Created by sanny007 - Sunday, December 8, 2013 2:17 PM | Last reply by sanny007 - Monday, December 9, 2013 6:35 PM -
2 Votes
Row filter vs. calculate
You should not add filter in "Calculated Field 1" measure.Answered | 2 Replies | 548 Views | Created by AlexMartini - Saturday, December 10, 2016 1:46 AM | Last reply by Angelia Zhang - Monday, December 12, 2016 1:52 AM -
1 Votes
How do I create percentage calculated fields?
Hello James, It is pretty simple, you just need a calculated column with a simple formula.Answered | 1 Replies | 1805 Views | Created by Maracles - Thursday, August 22, 2013 11:30 AM | Last reply by Olaf Helper - Thursday, August 22, 2013 4:18 PM - Items 1 to 20 of 2501731 Next ›
No announcements
