The total of part of a series of numbers
Questions tagged [subtotal]
398 questions
1
vote
0 answers
Angularjs ng-repeat: Adding values in Column which are getting fetched from MySQL, Sorting data
I am writing a piece of code for private tutions. It contains details of students which are stored in MySQL database.I am dislaying it with ng-repeat. I used PHP for fetching data. There are two things which are not working properly in code
In…
Manisha Chavan
- 69
- 7
1
vote
3 answers
Power Query Excel show values as percentage of column
Normally, PivotTables are used to present data in a certain order. For this specific "issue" I need to present numbers and a target.
This conflicts in Pivots as the percentage of column takes into account the target as well.
No worries, with…
significant
- 153
- 7
1
vote
1 answer
Tableau Insert Customized Rows of Subtotals
I have a data set with 13 rows, each representing a product type. Those 13 products then divided into 3 groups (an image of the data is attached below),
the first 7 products are in Group1
the next 3 products are in Group2
the last 3 products are…
Yao lu
- 37
- 7
1
vote
1 answer
Grand total with each summation in crystall report
I have data like this
Type Buy Sell
Car1 23000 15000
Car2 24000
Car3 25000
I used sum(@buy) for total buy field and sum(@sell) for total sell field.
Can I sum all or grand total that like sum(@buy) + sum(@sell) ?
because when I run…
axna2000
- 29
- 5
1
vote
1 answer
Count rows with "x" in at least one of the previous 4 cells
I want to count the number of rows by Region (D1) and Manager (F1) which have at least one X in the previous 4 cells from specified Month (B1). Here is the code I have been able to put together but it only adds all the X's in the specified rows.…
ABBO
- 27
- 2
1
vote
1 answer
Lookup headers and use COUNTA to sum the data under it
I am trying to find a specific column based on month (B1) and count the number of cells with x under it based on by the designated region (D1).
This is what I figured it would be but it is coming back as…
ABBO
- 27
- 2
1
vote
3 answers
Sum only visible cells in one ROW (not column)?
I have a row and I want to sum only visible cells, i know if it's a column I can use subtotal (109,range), but this one doesn't seem to work for cells in one row. Anyone knows how to sum only visible cells in a row?
Please click here for picture
emma12345
- 107
- 4
- 10
1
vote
1 answer
Excel Counting Occurrences Without a Preset Range
Good Evening. I am trying to count how many offices each company has in each country. For instance, 24 Hour Fitness has office as follows:
China 2
Hong Kong 6
etc.
I can subtotal it, but I want it in its own column. I have tried to do this in…
Anthony Russo
- 13
- 2
1
vote
2 answers
Datagridview column total
I tried to calculate the total of the column named QTY in the datagridview.
But I coul not.My code is below. Could you help me , please?
public int RowCount { get; set; }
[BrowsableAttribute(false)]
private void…
Bahadir
- 11
- 4
1
vote
1 answer
R dcast: applying value/conditional exclusions to sub-totals
I have a two-parter question. In creating a dataset similar to what I have, we can start with the airquality dataset:
myaqm <- melt(airquality, id=c("Month", "Day"), na.rm = TRUE)
myaqm_dcast <- dcast(myaqm, Day+variable~Month,
value.var…
Belinda-Jane Netan
- 527
- 6
- 12
1
vote
1 answer
Calculating subtotals using jquery
How do I go about fetching from (or writing to) input fields relative to $(this) in a form?
I wish to loop through all input fields "antal" and calculate subtotals based on "antal" multiplied by the price relative to "antal" and store the calculated…
Ktraving
- 45
- 8
1
vote
3 answers
How to find row at which summed total is greater than a certain amount?
I would like to find the row at which running summed value has reached a specified amount and several criteria have been met (similar to sumifs).
I can't just add a cumulative row, as suggested here:
Count rows until the sum value of the rows is…
Brian
- 83
- 1
- 1
- 11
1
vote
4 answers
MySQL finding subtotals
EDIT:
I'm told that making you guys read means I get less attention. My apologies. Here's a simpler version:
Bill got $100 dollars worth of items from a store.
He wants to return enough of the items to get exactly $30 dollars back.
The store has a…
Anthony
- 36,459
- 25
- 97
- 163
1
vote
1 answer
Calculate all item totals to subtotal Jquery
Note: bunch of people have had similar questions but my code is set up a little differently so those solutions won't work here.
I have a subtotal variable that should add each total(price * quantity) for each item and return the combined total. I'm…
TYPOI
- 361
- 2
- 6
- 19
1
vote
1 answer
Spotfire - Finding Percentage of Subtotals
I'm trying to turn a cross table that looks like this
into a table which shows the subtotals and percentage over each Group like the example below
Where the percentage is the sales of each product divided by the total sales in each group, so for…
DLWEB
- 23
- 1
- 4