The total of part of a series of numbers
Questions tagged [subtotal]
398 questions
1
vote
1 answer
Magento getData from guest on success.phtml
I am trying to get the subtotal amount on checkout success page. It works good for registred users:
$_order = Mage::getModel('sales/order')->loadByIncrementId($this->getOrderId());
$amount = $_order->getData('subtotal');
$total =…
nicmare
- 170
- 3
- 11
1
vote
1 answer
ORACLE - Calculate two values and show result in a view
I received fantastic help from Dave Costa and Justin Cave here (thanks again) in how to calculate a subtotal value from two other attributes, Quantity and Price (so Quantity * Price = Subtotal). In one of the answers it was stated that from a…
Mo Moosa
- 937
- 2
- 19
- 39
1
vote
1 answer
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
Pivoted_data =…
user18233539
- 129
- 1
- 2
- 8
1
vote
1 answer
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 total of subtotal.
if I could get a array of all…
kishore kumar
- 27
- 5
1
vote
0 answers
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
bmi_Obese …
ad9820
- 11
- 2
1
vote
2 answers
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',…
carevans88
- 79
- 1
- 4
- 16
1
vote
1 answer
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 to get the sum by the first pivot columns (a sub…
Ben
- 13
- 3
1
vote
1 answer
How to add percentage by each category in Python pivot table?
I am working on a survey and the data looks like this:
ID Q1 Q2 Q3 Gender Age Dep Ethnicity
001 Y N Y F 22 IT W
002 N Y Y M 35 HR W
003 Y N N F …
Sandy
- 359
- 4
- 14
1
vote
1 answer
Plus and Minus the Quantity of selected item only in the Cart and total price - React Redux
I want to plus or minus the quantity of an item which is added in the cart. The issue is when I add another item to the cart and then when I plus or minus the quantity then the other item's quantity also changes. Also when quantity changes I want to…
user16511963
1
vote
1 answer
Using FILTER inside SUBTOTAL in google sheets
I have a table in google sheets with columns including "year", "industry", "total carbon footprint" and "carbon footprint per employee" . The table has filters so you can look at the average carbon footprint for different industries for example.
I…
wilburforcethebrave
- 21
- 4
1
vote
1 answer
How to subtract subtotal from total in WooCommerce?
In WooCommerce, I'm wondering is there a simple solution to subtract the subtotal from the total without adding another fee? And have this appear in all places such as checkout, orders (Woocommerce), my orders (my-account/view-order/) etc.
The…
Ross
- 453
- 4
- 16
1
vote
1 answer
Vue.js Element UI el-table: How to merge cells and subtotal them
I got an original table like this
| category | name | price | count | subtotal |
|----------|-------|--------|-------|----------|
| fruit | apple | 2 | 10 | 20 |
|----------|-------|--------|-------|----------|
| fruit |…
new
- 49
- 2
- 10
1
vote
1 answer
How to add subtotals to groupby and rank those subtotal categories in descending order?
Sample Dataset (Note that each combination of Col_A and Col_B is unique):
import pandas as pd
d = {'Col_A': [1,2,3,4,5,6,9,9,10,11,11,12,12,12,12,12,12,13,13],
'Col_B':…
Jiamei
- 405
- 3
- 14
1
vote
2 answers
How I can two subtotals summarize in the table SQL Server Managment Studio 2014?
I have an SQL query which returns orderid and quantity ordered for all orders with an orderid >= 11075 and orderid <= 11076:
select orderid, quantity
from [order details]
where ((orderid >= 11075) AND (orderid <= 11076))
My ResultSet is:
But…
stfxc
- 174
- 6
1
vote
1 answer
Calculating sub-total in each group
I need report from multi table I use this query (SQL Server)
Select CASE When ([bills].[BT] ='0' and [bills].[T] = 1 )Then 'Purchas1'
When([bills].[BT] ='0' and [bills].[T] = 3 ) Then 'Output'
When([bills].[BT] ='0' and [bills].[T] = 4 ) Then…
Mohammed Rabee
- 345
- 2
- 8
- 23