The total of part of a series of numbers
Questions tagged [subtotal]
398 questions
1
vote
2 answers
SSRS, subtotal on each line
I just tried to make a grouped table in ssrs (let me show an exemple, more explicit than words...)
Date | group1 | group2 | qty | qty2 | sum
---------------------------------------------
20150202| ADSL | france | 500 | 300 |1600
20150203| T1…
Ronandroid
- 53
- 1
- 9
1
vote
2 answers
Sub-total and total columns
In Visual Foxpro 9 I am trying to write an sql with a product "subtotal" column and a report "total" column.
The sql code that works is as follows, but when I insert the commented out "Case" code I get errors that seem to increase as I correct the…
Tass-man
- 15
- 4
1
vote
1 answer
Using "+=" operator in PHP
I have a foreach loop that I'm running through JSON data. One of the values in the JSON is a number:
{
"apiVersion": "0.1",
"data": {
"offset": 0,
"limit": 50,
"count": 50,
"total": 783,
"reports": [
{
"type":…
ValleyDigital
- 1,460
- 4
- 21
- 37
1
vote
0 answers
Display subtotal in EXCEL pivot CHART
Hi there and thanks in advance for all of you who'll help me on this dead end (for me).
My issue is quite simple to explain: I want to display subtotals on my Excel Pivot Chart, like a line showing the total of the categories.
Here is what I…
willily
- 106
- 1
- 4
1
vote
2 answers
Python Pandas sub-totals and grand total
I have the following table:
How do I either break out the table so that it only has the headers:
Peat-Forming, PBL_AWI, CM, LBH
and the values remain the same as shown? Doing this I believe would make it possible to add sub-totals and grand totals…
Tristan Forward
- 3,304
- 7
- 35
- 41
1
vote
1 answer
Subtotal and Count in Same Row Macro
I have a report that I am trying to generate that shows loans made outside of policy, grouped by loan officer, with subtotals of dollar amounts of loans made outside of policy. I would also like to have a count of the number of loans made, but I…
Henchman21
- 43
- 1
- 5
1
vote
2 answers
Change subtotal with given price & quantity (custom attribute)
My price is for example 10,00 €
this price is for 100 g
the customer can add any g in the quantity field for example 300
magento has now a subtotal of 3000, its ok but not for my needs here.
i need to do:
if price & quantity is set, get subtotal /…
user715449
- 113
- 1
- 2
- 12
1
vote
1 answer
Passing a total between groups in crystal reports
Group 1 = Date of order
Group 2 = product and current on hand
Day1
20140423 (Day 1)
product A 200
Order 1 -20
Order 2 -20
Balance 160
Product B …
kengol
- 11
- 1
1
vote
3 answers
SQL How to create output with sub totals
I'm new to T-SQL and need help converting an excel report to a run on SQL. I have a SQL table that records all the daily inventory transactions (in/out) from each stockroom. I need to create a report that list the current inventory levels for each…
Russell Peters
- 35
- 1
- 5
1
vote
1 answer
Group or sort values in calc (libre office)
Sorry for non-programmatic question - I need a help with libre office tools.
I have (for example) such table, where the first column is an IP addresses
A B C
2.3.4.5 bbb 22c
1.2.1.4 aaa 11v
4.2.3.5 ccc …
curiousity
- 4,703
- 8
- 39
- 59
1
vote
1 answer
Excel 2010 - Count Unique values only in a SUBTOTAL cell
Info: Excel 2010 (no macros)
Data Origns: MySQL Query / phpMyAdmin Server: Apache
Code is run via: Server SQL Query (copy & paste in the phpMyAdmin) or in MySQL Workbench or using a custom shopping cart manager.
Exports to: Excel (.csv then to…
MrsAdmin
- 548
- 5
- 12
- 34
1
vote
1 answer
having trouble getting the subtotal from the cart in magento?
I am trying to get the subtotal from the cart using the code
getQuote()->getSubtotal(); ?>
It only works when i clean the cache, i don't know why. how to get the subtotal in a correct way? . Any help will…
jarus
- 1,853
- 11
- 44
- 76
1
vote
1 answer
Formatting subtotals in a matrix report
So I have a matrix report where the formatting from my data cells is not inherited by the subtotals. I read this article (http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d4d21769-2cb0-4bb1-b74b-89e4d31fb724) and it seems I…
Ryan Ward
- 1,523
- 4
- 15
- 23
1
vote
2 answers
Excel 2010 - Subtotal of values with override fields
I have an excel sheet that needs to calculate the sum of values. Values can be in one of two fields, and if it is in the second one, I want to disregard the first one.
Row1: Default value | Override Value
Row2: 1 | 2
Row 3: 4 …
Mark
- 47
- 2
- 7
1
vote
2 answers
how to update cart total after change item price with observer?
I want to add some free gift to cart , so I create an observer, the code is:
getEvent();
$quote =…
Leon Lai
- 33
- 1
- 2
- 5