Hi,
I want to use a subform for drill down reporting, that is select the year,
then the month using the forms nav bar which works fine.
Below the form I want to display textboxes which may show the total of selected (filtered) records, average, highest ,....
Not sure if that actually can be done with using the nav bar for autofiltering as this does not provide a hook
for the where clause in the query for the textboxes
Do I need a filter table and listboxes for this or is there another option ?
Thanks for any ideas.
[Solved] Statistics of autofiltered records in subform
[Solved] Statistics of autofiltered records in subform
Last edited by Hagar Delest on Thu Sep 17, 2020 12:58 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Re: Statistics of autofiltered records in subform
This is easily doable with a filter table and some SQL.
Code: Select all
SELECT SUM("blah") AS "Sum", COUNT("blah") AS "Count", AVERAGE("blah") AS "Average"
FROM "Table", "Filter"
WHERE "Filter"."ID"=1
AND (same criteria as the subform filtered by the same filter row)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Statistics of autofiltered records in subform
Thanks Villeroy
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend