408 questions
0
votes
1
answer
44
views
Totals from specific parts of a large spreadsheet by row and column
Here is a large spreadsheet with several years' worth of data in a lot of categories.
Y = year, M = month, D = day
A B C D E
1| Y | M | D | 1 | 2 |... Initial dataset
2| 19 | 1 | 1 | ...
- 1
4
votes
2
answers
128
views
Adding subtotals to a pandas dataframe
I was looking to add subtotals to a pandas dataframe - a question which I found to be asked here often. The answers making use of the deprecated pd.append aren't relevant anymore so I figured a more ...
- 109
0
votes
1
answer
109
views
Can You SubTotal a Column that contains formulas, but Ignore Unanswered Formula?
I have a column of data that is populated by a Vlookup.
=IFNA(VLOOKUP(A9,'STRUCTURAL E3D DATA'!G$3:J$2000,3,FALSE),"")
I need to sub-total this column, but without it just counting all the ...
0
votes
1
answer
60
views
DB2/LUW - How to get group totals and sub-totals without a null label for the grand total?
I've read the answers for group totals with sub-totals. But none of them seem to address the issue of having a NULL label for the grand total. I tried both ROLLUP() and GROUPING SETS but they both ...
- 163
1
vote
2
answers
77
views
Excel statistics for subtotal table values
I've been trying to create an excel analysis with the following statistics for each of the _count columns in my data set:
MAX
MIN
MEAN
MEDIAN
MODE
Furthermore, I have additional requirements that ...
- 17
-4
votes
1
answer
94
views
Advanced use needed for Subtotal function, in Excel v.16
I am trying to Subtotal the following function(s): =SUMPRODUCT((B2:B2340<>"")/COUNTIF(B2:B2340,B2:B2340&""))
However, all the Subtotal options are preset functions that ...
0
votes
0
answers
70
views
PowerBI matrix total not totalling rows shown in Matrix
I'm new to Power BI and have come across this issue. In power BI i am working with a csv file called 'EUTaxonomyCSRD'. In the file I have a column called 'Location Name' that defines the location ...
- 19
1
vote
3
answers
136
views
Average subset of sorted filtered values
I have the following set of values:
col1
Col2
1
20
2
155
3
170
4
177
5
291
6
559
7
794
8
820
9
1,198
10
1,240
11
1,259
12
1,537
13
1,613
14
1,876
15
1,949
16
1,950
17
2,274
18
2,372
19
2,640
20
3,030
...
- 25
0
votes
2
answers
106
views
countIf only in Visible cells of a table in excel
I have a table
I want to return the number of all the cells in a column which is equal to "Defined"
I don't know to how to refer to the last line of my column in the following formula
=...
- 927
0
votes
2
answers
52
views
Excel query when subtotalling
I have a large set of data that has clients name, product type and then premium. I want to group all the clients products together and then delete any clients where their total premium is more than ...
- 1
1
vote
1
answer
158
views
Why is my subtotal macro running so slowly? It is taking about an hour to run
There are about 4000 rows of data, and macro subtotal takes about an hour to run. Doing the subtotal manually takes about 40 seconds. Can anyone help to check my code?
Below is my code:
Sub XX()
...
- 11
2
votes
3
answers
132
views
Total and Sum of two columns in a single query
My requirement is similar to this question & answer PostgreSQL - Calculate SUM() of COUNT()
But need the total by another column
I have something similar to this
create table Item
(
ItemID ...
- 543
0
votes
0
answers
166
views
Excel: Applying SUBTOTAL() within VSTACK() (for a Sum of a Filtered Column)
INTRODUCTION / DESIRED RESULT
I am trying to create a table that automatically updates and that can be filtered. In this table, I want to add a dynamically column total at the end of the 'time ...
- 1
0
votes
1
answer
97
views
Why does pivot table show weird totals?
I have a filtered pivot table with multiple fields in the 'rows' section.
When you calculate the total of the numbers in the rows, I get a totally different total than what is shown as total in the ...
- 359
0
votes
1
answer
65
views
R table with values of all rows and columns
I have a long table and want to have a long table with the sum of each column and each row and total sum.
AUX
Century
n
launch
19
500
launch
20
500
launch
21
500
throw
21
500
launch
16
153
throw
20
...
- 7
0
votes
1
answer
67
views
Dynamically Updating WooCommerce Product Subtotal Based on Quantity [duplicate]
I am trying to have my on-page subtotal for individual WooCommerce products update on a per-quantity basis. I have found a solution that works perfectly for simple products via the following URL: ...
- 21
-3
votes
1
answer
123
views
Google sheets - workaround for filtering with non-edit access / using SUBTOTAL to find filtered values
I am looking for a workaround to a specific problem - I have spreadsheets with pivot tables that are accessible to people with commenter access. I would like to give them an option to filter some of ...
- 139
0
votes
1
answer
134
views
java apache poi close subtotal and the excel is corrupted
i use java apache poi to generate pivot table and when i use setOutline(false) to let the pivot table show in parallel form rather than in outline form, it will add subtotal row. That's weird. and ...
- 1
0
votes
0
answers
57
views
Get subtotal when filtered
I am using the below formula to total the columns from AX4:BI. When I filter by manager, the total stays the same instead of just showing their cost. How can I make the total filter with the selected ...
0
votes
1
answer
93
views
Excel subtotal where the reference only shown once
does someone know How I can make the Excel to provide the subtotal based on the Company?
When I try the standard subtotal then it does not give me the right subtotal.
- 189
0
votes
2
answers
773
views
Calculate the average of a filtered list/column with a condition (libre office calc)
I'm trying to calculate the average of a filtered list (J23:J1026), but with a condition.
The condition is to calculate the average of the values < 0.
I was able to get the count of the values < ...
- 51
0
votes
2
answers
308
views
Subtotal SUM does not work properly when more than 24 hours
I have the following data in column H:
=SUBTOTAL(109;H3:H9999)
hours
02:15
03:30
03:30
00:15
00:15
02:00
00:30
00:30
04:00
00:30
05:45
02:15
00:30
02:00
01:00
I want to have the subtotal with function ...
- 1
0
votes
1
answer
347
views
DAX Subtotal PowerBI
I need to create a measure having the SUM of the column "Sales" each time a value in the row "Month" appears.
`e.g. In a row I have this two values:
Sales= 500
Month= April
I need ...
0
votes
1
answer
186
views
How to get the number of records that match all conditions in a filtered, external worksheet?
I have a simple and small file which does some counting in an external workbook. The data in this external workbook is filtered using autofilter (for example: a specific time range).
Let's name the ...
- 359
0
votes
1
answer
60
views
How do i add a column of totals only if the "Name" variable is the same
enter image description here
I am trying to keep track of inventory and we use the Frebreeze for example,
There are 2 cases of 6 so 12 sub total.
Lets say we buy 2 of those, and there are two separate ...
- 1
0
votes
0
answers
104
views
Subtotal in Excel by Python
this is my code without any error
xl = pd.ExcelFile("D:/write_data.xlsx")
df = xl.parse("Sheet1")
df['C'] = df['C'].astype(str)
df = df.groupby(["A", "B", &...
1
vote
1
answer
457
views
How to add SUBTOTAL to SUMPRODUCT with division formular in Excel?
Below are some raw data with related formular:
Col A1, A2 & A3: 4, 6 & 12
Col B1, B2 & B3: 100, 150 & 120
Formular: = SUMPRODUCT(B1:B3/A1:A3)
I tried to add SUBTOTAL function in ...
- 11
0
votes
0
answers
163
views
Power BI average of averages of averages DAX measure
I have datas seems like this :
We have to calculate the averages of the column "value", however we have to follow the rule : "all component have the same weight in a product, all ...
- 29
1
vote
1
answer
299
views
Adding subtotals to pivot_table using groupby
I'm trying to include subtotals in my pivot_table.
Pivot table code
# Specify the aggregation functions
aggfunc = {'amt': 'sum', 'llp': 'first'}
Pivot and calculate aggregated values using aggfunc
...
- 158
0
votes
1
answer
55
views
I want to create a running subtotal based on the quantity added of different food items. What am I missing?
print("Welcome! Here is today's menu.")
print("")
print("- Coffee ($2)")
print("- Burger ($4)")
print("- Juice ($3)")
print("- Muffin ($2)&...
- 1
2
votes
3
answers
87
views
Calculate subtotal with special condition
id
flow
amount
date
1
IN
100
2023-08-01
2
OUT
100
2023-08-02
3
IN
100
2023-08-03
4
OUT
100
2023-08-04
5
OUT
100
2023-08-05
In a table like above, I want to sum all OUT transactions which take place ...
- 115
-1
votes
1
answer
3k
views
Subtotal with countifs in different columns
From given table i want to count number of text "Yes" from Result column where numeric value is 25 or 35 from number column. I want to use subtotal here as i have to filer data on groups.
- 31
1
vote
1
answer
43
views
how to sum all input values from forminput? The input field was rendered using map method
I calculated the subtotal with child component by passing the arguments as I could not calculate in the parent component itself.
Here I used map method for form input. Now I need to calculate the ...
1
vote
0
answers
63
views
R programming-Survey Function (SVYBY)
I am new to R and would like some help on the survey function
I am using svyby function to do cross tab
for example: svyby( ~bmi,~Race, design, svymean, na.rm = TRUE)
and getting the result
...
- 11
0
votes
1
answer
519
views
DAX Formula Issue - Detail level correct, but subtotals and totals not
I'm very new to DAX and strugglingly to understand how to correctly get subtotals for my formula. My formula correctly calculates at the detail level, but I want it to sum the detail rows for the ...
- 21
0
votes
2
answers
58
views
How can I add numbers of table row in a table using jquery?
I'm able to add numbers from input to the table on click of a button. But I can't get the total of all the numbers in the table on click of the button.
How can I add the numbers of the table row on ...
user21427607
0
votes
1
answer
316
views
flutter - cartscreen and total price
I want to display the total price on the button like this "buy now $15" $15 is the total price, now I'm confused about how to do it, I've tried it but the results are not what I want.
this ...
- 13
0
votes
1
answer
583
views
How to use Subtotal in a Filter Data with ArrayFormula
I've created a simple table and trying to sequence datas with Subtotal (CountA) in my Filter Datas.
Datas
A: Subtotal with ArrayFormula
B: Subtotal without ArrayFormula
Here is my exp:
https://docs....
- 13
1
vote
2
answers
82
views
Create conditional multi-index subtotal on pivoted dataframe
I have a multi-index pivot table looks like the following, where Date is the index, and columns are [country, attributes]:
net_supply = pivot_filter.pivot_table(values='Production', index='Date', ...
- 131
0
votes
3
answers
153
views
Creating a function similar to subtotal, that ignores hidden columns
I am trying to find a replacement for subtotal or aggregate that will sum all cells in a range except those whose column is hidden. Absent the presence of a builtin function I am trying to create my ...
- 25
0
votes
1
answer
110
views
How To Get Nested Groups To Work On Razor Page?
I'm trying to get a table to display so that my groups "group" correctly. Below is what I have tried. It runs, but repeats ALL of the ArrestOfficers under each Arrest Dept.
For example, ...
- 183
0
votes
1
answer
162
views
How Do I Total a Filtered Column on a Razor Index Page Table?
I am trying to create a report that a user can filter using my Index.cshtml. The report is working correctly and I have one total in the footer that works just fine.
My issue is that the second total ...
- 183
2
votes
2
answers
255
views
How to calculate running total of the subtotal
So I need to calculate a running total of both "sub_total" so both of these prices are added together and display in the "overall_total" variable. Currently, the output is showing $...
- 21
0
votes
1
answer
426
views
Summing time in Excel table gives very large number?
Can anyone help please?
When I sum two time value such as 09:00 and 22:30 I can get a result of 31:30 by formatting the cell using [h]:mm:ss.
However, whenever I try and do this with a subtotal row on ...
0
votes
1
answer
380
views
I'd like to make my plus and minus button change that sub total and total price, but the price didn't change, anyone can solved my problems?
here is my code, i've tried to cummulative the price with quantity per product but still stuck, anyone can solved my problems? i need your help guys, thanks for tryin' my code
<td>
{{-- <...
0
votes
1
answer
43
views
How to get/find the sum of all numbers starting with 1 and ending with N using Bash or similar
How can you get/find the sum of all numbers starting with 1 and ending with N using Bash or similar? For example 1 to 50.
- 2,246
1
vote
2
answers
1k
views
Pandas : add sub rows sum in multi-columns pivot
I've got a dataframe build fromRecordsa django queryset, that I pivot by 2 columns to get a dashboard view of it.
I manage to have the global sums byr row and column of the whole table, but I'm trying ...
- 45
0
votes
0
answers
3k
views
Table Total values of some columns not showing, power bi
I have this table. All of the columns are after measure. As you can see some column totals are shown, some are not.
If some total values are correct, others are not (for example,only 3 and 5 column ...
0
votes
0
answers
78
views
Delete Total Line in SAS
Does anyone know of a way to remove the last blue total line?
This is the code I currently have:
title1 'Physical Exam Results By Patient';
footnote1;
proc print data=cert.transvisit1 noobs ...
- 11
0
votes
0
answers
120
views
Subtotal with a sumproduct?
I have read multiple answers on here and tried to implement how would i do this? Just want to add a subtotal?
=SUMPRODUCT(E$9:E$500,MOD(ROW(E$9:E$500)+1,2))
