quiz to impromptu

[shulbert at clblf.com]

seeing that the cognos bi helpdesk person seemed unaware that there was a product called quiz, in desperation i'm asking the list.

i'd like to reproduce the "subtotal at" functionality in impromptu.

that is, subtotal a value only once per sort group.

<data>
Rep   Year  Month Budg£ Invoice    Amount£
------------------------------------------
Rep1  2005  1     1000  IV000001    57.91
Rep1  2005  1     1000  IV000002    34.51
Rep1  2005  1     1000  IV000003    37.66
Rep1  2005  1     1000  IV000004    86.57
Rep1  2005  2     1010  IV000005    41.69
Rep1  2005  2     1010  IV000006    58.46
Rep1  2005  2     1010  IV000007    59.62
Rep1  2005  2     1010  IV000008    26.15
Rep1  2005  2     1010  IV000009    52.23
=========================================
Rep1	2005		2010		     454.80
</data>

i.e. the budget amount on the summary line is the sum of the budget figure for each month, but only including that figure once.

<quiz>
access invoices &        link rep to rep of rep_budgets
sort on rep on year on month
footing at year rep year budget subtotal at month amount subtotal
go
</quiz>

many thanks for your patience,
stephen.



CLB Littlejohn Frazer
Chartered Accountants
1 Park Place
Canary Wharf
London
E14 4HJ

Tel 020 7987 5030
Fax 020 7987 9707
www.clblf.com

The information contained in this communication is confidential and may be
legally privileged.  It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it.  If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking of any action in reliance on the contents of
this information is strictly prohibited and may be unlawful.

CLB Littlejohn Frazer reserves the right to monitor the content of any
message sent to or from clblf.com.

A list of partners may be inspected at the above address which is also the
address for serving documents.

CLB Littlejohn Frazer is registered to carry on audit work by the Institute
of Chartered Accountants in England & Wales, and authorised and regulated by
the Financial Services Authority for investment business.

CLB Corporate Finance LLP is authorised and regulated by the Financial
Services Authority.