No announcements
Found 1992857 threads
-
0 VotesSUM that filters out data
A query like this is perfectly valid: SELECT SUM(Profits) FROM my_table WHERE internal='no' Gert-JanAnswered | 2 Replies | 779 Views | Created by Jumpy99 - Friday, February 28, 2014 2:32 PM | Last reply by Gert-Jan Strik - Friday, February 28, 2014 3:11 PM
-
0 Votes
Sum Specified Value in Filter
All in all I would build a measure using: RANKX, SUM or SUMX and eventually ALLSELECTED.Answered | 2 Replies | 1140 Views | Created by MRomulus - Monday, March 31, 2014 4:35 PM | Last reply by Matthaeus Woroch - Tuesday, April 1, 2014 12:02 PM -
5 Votes
formula for summed filter
Yes, SUMX effectively loops over the table or table expression in the first argument and evaluates the scalar expression in the second argument and sums ...Answered | 5 Replies | 849 Views | Created by AlexMartini - Wednesday, November 23, 2016 7:13 PM | Last reply by Darren Gosbell - Tuesday, November 29, 2016 11:41 AM -
0 Votes
How to filter by date to SUM a field?
Edit: See sample: declare @test varchar(50) set @test = 'August 01, 2012' select ...Answered | 2 Replies | 2134 Views | Created by Kaycey - Tuesday, September 18, 2012 4:50 PM | Last reply by i_h - Tuesday, September 18, 2012 7:46 PM -
0 Votes
MDX Filter and Sum
type=forum&referrer=https://social.msdn.microsoft.com/Forums/sqlserver/en-US/48384e40-0288-436f-a843-32e62282b913/mdx-filter-and-sum?Answered | 2 Replies | 6504 Views | Created by Itz Shailesh - Tuesday, August 1, 2017 10:12 PM | Last reply by Itz Shailesh - Wednesday, August 2, 2017 1:50 PM -
0 Votes
Sum value by column filter
Try using the below: =Calculate(Sum(Exp[Release_Note_Qty]),Exp[Pipe_POS_1]=1) By embedding the code in calculate function you will be able to get the ...Answered | 2 Replies | 4919 Views | Created by KZMANUS - Monday, May 14, 2012 3:18 AM | Last reply by KZMANUS - Monday, May 28, 2012 2:24 AM -
1 Votes
select with filtered sums
You can do this using subqueries, as follows DECLARE @Table1 TABLE(CustomerID INT,ChargeID INT,Amount DECIMAL(5,2),TransactionType VARCHAR(20)) INSERT INTO ...Answered | 6 Replies | 3863 Views | Created by RickN - Friday, March 12, 2010 2:33 PM | Last reply by Naomi N - Friday, March 12, 2010 3:07 PM -
0 Votes
Sum measure over nested filter
You are trying to sum a ratio calculation and hence, are not getting the correct results.Answered | 4 Replies | 3276 Views | Created by liranbn - Friday, August 17, 2012 7:11 AM | Last reply by liranbn - Wednesday, September 5, 2012 8:21 AM -
1 Votes
Filter out blanks
Try something like : Mycalculation:=IF(SUM([Sales Amount])<>0;SUM([Sales Amount]);BLANK()) blank ...Answered | 1 Replies | 2997 Views | Created by syarbrou1 - Wednesday, February 13, 2013 8:31 PM | Last reply by the_txeriff - Thursday, March 7, 2013 3:22 PM -
2 Votes
Filtering data already filtered using DAX
It is taking 'Table' and filtering it by the sum of [Tariff] that is further filtered.Answered | 6 Replies | 1081 Views | Created by Andrew Noble - Monday, November 17, 2014 4:42 AM | Last reply by Michael Amadi - Tuesday, November 18, 2014 2:20 PM -
2 Votes
Filtering dimension by measure sum
Check out this ...Answered | 5 Replies | 4665 Views | Created by Milan Erić - Tuesday, November 2, 2010 1:54 PM | Last reply by Vinuthan - Wednesday, November 3, 2010 2:21 AM -
0 Votes
Getting a SUM out of a Group
Hi, AS Josh and daYoko has replied, we can apply sum out of group as: Go to group and do right click on it ...Answered | 4 Replies | 1767 Views | Created by SoapyJ - Friday, December 7, 2012 12:54 PM | Last reply by Fanny Liu - Monday, December 10, 2012 7:27 AM -
0 Votes
Beginner : filter out data in source
hi, i am new ssas, i am building a cube, the fact table i am using has around 90m rows, so i dnt want whole data, i just need to bring data into cube based ...Answered | 3 Replies | 3955 Views | Created by saurabh180407 - Tuesday, August 25, 2009 5:49 AM | Last reply by Prasanna K J - Tuesday, August 25, 2009 1:32 PM -
1 Votes
Summing data
Open your excelsheet, recode a makro and sum your values up.Answered | 3 Replies | 3289 Views | Created by GAMinTN - Wednesday, May 19, 2010 4:18 PM | Last reply by Liliane Teng - Monday, May 24, 2010 7:53 AM -
7 Votes
How get total (sum) property of (filtered) table?
I found that if your filter changes and the count of rows is the same as the prior filter, then the totals do not recalculate.Answered | 17 Replies | 1288 Views | Created by Simithie - Monday, July 20, 2015 12:08 PM | Last reply by Simithie - Wednesday, July 29, 2015 10:06 AM -
4 Votes
SUM of Sharepoint column - filtered values
It will only give the count for Toner No, I need to get the sum total of Quantity for each Toner No in purchases and Requests lists.Answered | 6 Replies | 5654 Views | Created by Jimmy P. Mathew - Friday, December 13, 2013 5:28 AM | Last reply by Jimmy P. Mathew - Monday, December 16, 2013 3:03 PM -
0 Votes
SUM (X) FILTERED
;with mycte as ( Select IDTABLE1, SUM (value) val from TABLE2 WHERE type = 'F' Group by IDTABLE1) Select Name,val from table1 t1 left uter join mycte m on ...Answered | 5 Replies | 531 Views | Created by evets66 - Saturday, March 25, 2017 4:45 PM | Last reply by TWoW2017 - Monday, March 27, 2017 6:42 PM -
0 Votes
Problem Summing data in a table
You can directly drag XXX to your data field and write the expression as =SUM(Fields!Answered | 7 Replies | 5876 Views | Created by vqcheese - Wednesday, March 9, 2011 7:41 PM | Last reply by PranithPranith - Wednesday, March 9, 2011 9:12 PM -
0 Votes
How to Group by and sum data wit out a data base
nbsp; .GroupBy(Function(r) r.DBCLACCT) _ .Select(Function(gr) New With {.DBCLACCT = gr.Key, ...Answered | 5 Replies | 585 Views | Created by Chris.Hartmann - Thursday, June 5, 2014 3:46 PM | Last reply by Franklin Chen - Thursday, June 12, 2014 7:35 AM -
0 Votes
MDX - Aggregate/Sum/Manual Filter
An example of a "MDX - Aggregate/Sum/Manual Filter" using an attribute hierarchy and excluding one element from the aggregation: WITH ...Answered | 2 Replies | 2463 Views | Created by gemmo1 - Wednesday, January 29, 2014 2:29 AM | Last reply by gemmo1 - Monday, February 3, 2014 11:11 PM - Items 1 to 20 of 1992857 Next ›
No announcements
