Hi

I have a field (Booked volumes) that gives the number of bookings we have by month. I have the month's as an ACROSS, and then different types of appointments as my BY. Nobody is interested in knowing how many bookings we have per month, they just want to know how many we have left. Right now, if I put the field as a BY, a new row every time there is a different value for the number of bookings (ie. I'll have a row that says 20 bookings, then 23 bookings, because there was 20 bookings left in March and 23 in April). I would like to just show 43 bookings as the BY field.

SUM
FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.REPORTED_VOLUME AS 'Volume'
FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.VOLUME_TYPE NOPRINT
FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.TARGET AS 'Target'
COMPUTE QBP_Variance/I6 = FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.REPORTED_VOLUME - FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.TARGET; AS 'Variance'
BY FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.FUNDINGQBP AS 'QBP Funding Group'
BY FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.YEAR_END_PROJECTION AS 'YE Projection'
BY LOWEST FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.BOOKED_MT_VOLUME AS 'Booked Volume' -*THIS IS WHAT I NEED TO BE A SUM
ACROSS LOWEST FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.MONTH AS 'Month'

This message has been edited. Last edited by: FP Mod Chuck,

You should be able to use BY TOTAL. Check the reference to make sure that you understand the syntax and use.

BTW, when you search for something as specific as "BY TOTAL" from the search box at the tech library, put the syntax within double quotes.

You should end up with something similar to this -

SUM
 COMPUTE BOOKED_VOL/D12 = FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.BOOKED_MT_VOLUME; NOPRINT
 FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.REPORTED_VOLUME AS 'Volume'
 FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.VOLUME_TYPE NOPRINT 
 FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.TARGET AS 'Target'
 COMPUTE QBP_Variance/I6 = FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.REPORTED_VOLUME - FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.TARGET; AS 'Variance'
BY FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.FUNDINGQBP AS 'QBP Funding Group'
BY FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.YEAR_END_PROJECTION AS 'YE Projection'
BY TOTAL BOOKED_VOL AS 'Booked Volume' -*THIS IS WHAT I NEED TO BE A SUM
ACROSS LOWEST FACT_QBP_3M_VOLUMES.FACT_QBP_3M_VOLUMES.MONTH AS 'Month'

T