My user (a BA/report developer) wants to be able to section a report so as to see the section heading values in the Map, but also wants to have an extra section in the same map called “Total” which contains the grand total of all sections. Clearly this can be done a totals table outside the section - but how to do this so as to create an extra entry in the sections map. I could do this by having a union of 2 queries, and using some custom SQL - but this doesn’t provide a general solution that a non-technical BA/report developer could use themself on any report. Ideas anybody? Solution preferred for Webi, but could also use Deski. (Environment = BOXI 3.1)
It is not the Sum of values that is the problem, it is adding a new entry to the Map tags to show “Total”. As an example, if there is a report sectioned by country eg Belgium, France, Germany, Italy then these countries will also show as entries in the map for the report. What is required is to add one extra entry to the Map i.e to add another section - called “Total” which would have the sums of all countries in the same format as each section.
There is a (complex) way to do what youre looking (with a union Query and some variables I think) for but it would take a technique that a normal user may not be able or want to do
Why wouldnt your user just have two report tabs for this One tab could be named Total with a regular un-sectioned table showing totals for all values. The other tab may be named Detail which is sectioned, in this way the report navigation map would all records for the Total for tab 1, and the distinct values for your section on tab 2.
Your suggestion is indeed one of those that I’ve discussed with the user. There’s also the solution of putting a table outside of the sections. These are both fallback solutions. However she wants it all!
Your thoughts about a union echo my own techie solution (if this were a report that I were to develop and deliver) but I need to find a solution that this non-technical and inexperienced user can use herself in developing her own reports. I think I’m gonna give up on the “having it all” approach and just let her choose between the techniques that we know exist for ordinary users.
(BOB member since 2004-04-13)
(BOB member since 2004-01-29)
One tab could be named Total with a regular un-sectioned table showing totals for all values. The other tab may be named Detail which is sectioned, in this way the report navigation map would all records for the Total for tab 1, and the distinct values for your section on tab 2.
(BOB member since 2002-08-19)