Stack Overflow
Stack Overflow

Questions tagged [subtotal]

The total of part of a series of numbers

398 questions
1
vote
0 answers

SPOTFIRE % of total in cross table

I would like to use the aggregation "% of Total" in a cross table to basically calculate the percentage of Total income per year per shop (see table below). However, it is not calculating correctly. It will do OVER AXIS ROWS instead of OVER…
Xav Dou
  • 83
  • 1
  • 1
  • 5
1
vote
0 answers

add different subtotals to the tax on my invoice

I am starting on the development of php and wordpress and I am looking to modify the subtotal on my invoice to make two that would correspond to the subtotal of the two taxes I own on my site. Like this: Subtotal 5.5%: €44.50€ Sub-total 20%:…
Sébastien Dupuis
  • 11
  • 2
1
vote
3 answers

R: pivoting & subtotals in data.table?

Pivoting and subtotals are common auxiliary steps in spreadsheets and SQL. Assume a data.table with the fields date, myCategory, revenue. Assume that you want to know the proportion of day revenue of all revenue and the proportion of day revenue…
hhh
  • 50,788
  • 62
  • 179
  • 282
1
vote
1 answer

Removing subtotals and totals from Pivot Table rendered by pivottabler library in R

I'm trying to recreate a pivot-table like dataframe in R Studio with the library(pivottabler). I have managed to recreate it almost exactly the way I would like it, but the current default pivot tables rendered includes the subtotals and totals…
MysteryChinaman
  • 13
  • 5
1
vote
1 answer

Adding a subtotal to a column in a Firebird SQL query

I need to see the subtotal in my AMOUNT field every time there is a change in the LEDGER_ACCOUNT FIELD I have done a lot of research on this and it appears that this is a job for union. But I am unable to get the union to add the total every time…
gdekoker
  • 185
  • 8
1
vote
1 answer

Display striked cart item subtotal when coupon is applied in Woocommerce

My goal looks like this: I tried this code to achieve this: add_filter( 'woocommerce_cart_item_subtotal', 'show_coupon_item_subtotal_discount', 100, 3 ); function show_coupon_item_subtotal_discount( $subtotal, $cart_item, $cart_item_key ){ if(…
Krystian
  • 887
  • 5
  • 21
  • 52
1
vote
1 answer

Why does my subtotal code counts 1 when there's no values?

so I'm running a code that filters my data and then takes the count of the data and inserts it into an excel file. I'm using this code to count the data: lastrow = Cells(Rows.count, "A").End(xlUp).Row count =…
Joel Bastien
  • 121
  • 2
  • 11
1
vote
3 answers

subtotals per category over multiple columns

I am looking for an efficient solution to add subtotals for every column in a new row for each category in the column 'id'. I am able to achieve the desired output by using the code below, but this approach is not efficient for large datasets. Is it…
Robert K
  • 71
  • 3
1
vote
1 answer

SQL Get subtotal in each group

Good Morning in my timezone My goal is : TYPE | CODE | PRICE | QUANTITY A 10 34 1 A 11 20 2 A 15 17 2 A Total 71 5 B 13 14 1 B 10 24 2 B Total …
tt0686
  • 1,771
  • 6
  • 31
  • 60
1
vote
1 answer

Excel 2017 Formula - Average data by month, while being filterable

I'm not a VBA coder, and I would prefer an excel formula if possible, the easiest solution will be the best one. Test workbook screenshot As you can see, I have plenty of columns, which are filterable. I am attempting to retrieve an average of…
Alexander Rhodes
  • 25
  • 4
1
vote
2 answers

subtotals by group R

I'm trying to find a function similar to SAS's Proc Means which will aggregate data and subtotal/total it by groups. For example I have: Var1 Var2 a b a c b b and I want to create: Var1 Var2 N a b 1 a…
Maken
  • 21
  • 4
1
vote
1 answer

Add Countif to Array Formula (Subtotal) in Excel

I am new to array formulae and have noticed that while SUBTOTAL includes many functions, it does not feature COUNTIF (only COUNT and COUNTA). I'm trying to figure out how I can integrate a COUNTIF-like feature to my array formula. I have a matrix, a…
PyjamaNinja
  • 293
  • 2
  • 8
1
vote
1 answer

VBA to add subtotal with variable range

I'm trying to figure out excel VBA code to add subtotal (=SUBTOTAL(9,__:_) formulas to multiple Total Rows within a worksheet. The issue is that the range for the subtotals can be any height. Per the image below, the hope is that the VBA code…
User22
  • 11
  • 1
  • 4
1
vote
1 answer

MultiIndex Pivot Table with Subtotals in Pandas

Helllo, I have the following data: date item_type item_name gold_exit 2018-01-25 type1 item1 1 2018-01-25 type2 item2 2 2018-01-25 type3 item3 3 2018-01-25 type1 item4 4 2018-01-25 type2 item5 …
George C. Serban
  • 67
  • 1
  • 8
1
vote
1 answer

Netting in a dataframe

I have a dataframe which I would like to clean by removing some offsetting lines (boxed positions) and doing some netting. Here is the source table: Type Name Strike Maturity Nominal Call Amazon 10 10/12/2018 1000 Put …
user8453031
  • 17
  • 6
1 2 3
…
26 27