total column

  1. 4

    Cumulative sum with max

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Calibri; color: #000000}</style>I'm trying to calculate the cumulative total up to a certain maximum. In the example below, I need column D to calculate the contribution amount (by multiplying Column B and Column C), but...
  2. N

    Urgent - Help making totals add up after rounding to whole numbers

    Morning guys, I have a column of values containing 3050 rows. Each row has a value from 0 - 50. The majority of cells are 1's, 2's etc. I need to create two new columns to the left, one of which has 50% of the value, and the next having 30% of the value. The trouble is, I've done previous...
  3. L

    Getting a grand total from a sum of a column and one field?

    :warning:I have recently started my AS ICT coursework and I am having one problem with one of my queries. I need to create an invoice query to show the total amount spent by customers while they stay in a camping site (I will use this query to make a report). I have 5 tables, these including...
  4. P

    Sum a PowerPivot Column

    I'm near the finish line and am but a simple Grand Total away from declaring victory over a hairy PowerPivot Table with intense backend DAX. Problem is PowerPivot will not display a Grand Total on certain columns due to the nature of the DAX. I can live with showing a Grand Total in a cell...
  5. N

    How to show full totals in Pivot chart and table when you filter on one customer?

    Hi, I have a table with customers, months and totals. If I filter on one customer the total keeps changing just to that one customer. How would I filter on one customer but show the full totals? Thank you
  6. J

    tallying sales amounts

    Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have four columns B, D, E, G <o:p> </o:p> Column B = list of sales reps Column D = sales amount product 1 Column E = sales amount product 2 Column G = sales amount product 3 <o:p> </o:p> So, I have...

Some videos you may like

This Week's Hot Topics