total column

<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...

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...

: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...

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...

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

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...