Stack Overflow
Stack Overflow

Questions tagged [subtotal]

The total of part of a series of numbers

398 questions
1
vote
0 answers

Power Bi matrix subtotal is not the sum of the values in the column

I am trying to create a "meetingroom occupancy" matrix in Power BI. The raw data contains bookings per day per Room. The maximum daily available time per room is 12 hours. I have created a Date Dimension Table for the dates. I have tried to change…
Bende
  • 91
  • 8
1
vote
2 answers

SSRS Show all subtotals for each currency at bottom of report

I'd like to show the subtotals for each group at the bottom of my report, rather than inside each group. How can I do this?
Conrad Addo
  • 424
  • 1
  • 5
  • 15
1
vote
1 answer

Hide free shipping when subtotal is greater than 0 in WooCommerce

I'm using Free Product Sample for the WooCommerce plugin and trying to set conditional free shipping only for a Sample product, sample product cost is 0 and therefore I'm trying to hide free shipping unless the order subtotal amount is 0. To put it…
Minhas
  • 93
  • 6
1
vote
3 answers

SQL How to Query Total & Subtotal

I have a table looks like below where day, order_id, and order_type are stored. select day, order_id, order_type from…
ddd948
  • 49
  • 1
  • 5
1
vote
1 answer

Add Total column to Dynamic SQL pivot

Lots of these types of questions out there, but unable to find anything that matches what I am looking for. I am using code from another post that is working great, but I would like to modify it to add a totals row at the bottom of the table. The…
S Stef
  • 53
  • 1
  • 5
1
vote
1 answer

How do I make my added products to sub total price?

How do I make my added products to total price? Meaning I did some code to sub some products prices but it doesn't work?! It just print on last product the total which I want to be sub all products Here's the code: function.php function…
saeed Omar
  • 11
  • 3
1
vote
1 answer

dataframe subtotal and percent

I have a dataframe which looks like this: My end goal is to calculate the percent of each purpose and for each origin so the final table should look this: Any assistance or direction will be greatly appreciated :) Thanks in advance :) Shei
Py_junior
  • 93
  • 1
  • 10
1
vote
2 answers

Beginner Java problem regarding storing totals and finding the average

I am doing my first coding course and I have run into an issue with my loops. I am supposed to write a program that takes the user input of a specific quantity and specific price and multiplies them together, and finds the averages of my purchase.…
Sk8rTalent
  • 11
  • 1
1
vote
3 answers

Calculating subtotals from SQL query

I have a query which returns some rows. Its column names are like: Age, Gender, DOB etc. What I have to do is, to check how many rows are coming from DB of which Age. E.g. see the image: See the age subtotal, it means my query is returning 54 rows…
asma
  • 2,795
  • 13
  • 60
  • 87
1
vote
1 answer

Pivoting data.table where order matters for some functions and not for some functions?

I am practising in pivoting data.table, example below with lapply to get substructure features and their corresponding columns where ordering matters for the key column, this could be seen as pivoting in spreadsheet tools. This is similar to…
hhh
  • 50,788
  • 62
  • 179
  • 282
1
vote
1 answer

How to calculate subtotals, line by line of a Data Frame in Python?

I have the following DF: import pandas as pd df = pd.DataFrame([['2020/01/01','A',5],['2020/01/10','B',-2],['2020/01/15','C',3],['2020/01/18','B',9]],columns=['datetime','broker','amount']) I need to calculate subtotals row by row of the "amount"…
Kl Urt
  • 13
  • 4
1
vote
1 answer

how to transfer columns of python generated pivot table into new excel sheet?

I have a pivot table generated using python code: Date Grand Total Name 1/2/2010 2/2/2010 Alice 5 6 11 bob 5 5 10 Clarke 4 8 …
Lann
  • 33
  • 4
1
vote
2 answers

Subtotal, Shipping, Discount and Grand Total Missing in Magento

Hope someone can point me in the right direction. I am not a Magento developer but am having to fix my site after my "developer" left me with most of the work to do. Currently in my checkout screen i'm not seeing any values other than that of the…
Fred
  • 11
  • 1
  • 2
1
vote
1 answer

DJANGO - Subtotal by category and total by item

Good evening ! Let's assume I have a database with : Category | Item | Price Cat1 | Item1 | $1 Cat1 | Item2 | $2 Cat2 | Item3 | $3 Cat2 | Item3 | $3 Cat2 | Item4 | $4 I would like to display the total sales by category and below the sales details…
MichaelS
  • 259
  • 2
  • 13
1
vote
1 answer

Influence of subtotals on significance tests in expss tables

Hello to R/expss experts! This is a follow-up question to this one --> Complex tables with expss package. I added subtotals to already complex tables using the excellent expss package, and it works well for most tasks (counts, proportions,…
Maxence Dum.
  • 121
  • 1
  • 9
1 2 3
…
26 27