Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is it possible to show more totals in a table.
In Chart properties -> Expressions -> Total mode only one.
I wanna see the max, min, average and sum of each range.
Gr,
Ralph
If you want to show everything together, you can have New Statistics Box..
Go to empty space and right click and select New Sheet Object
Now Select New Statistics Box and use whatever Fields you want with Available Functions..
I agree with Manish, probably a Statistics box would help you.
Hello Manish,
Thanks for the quick response.
The answer is good if I have 1 range.
My question was not clear.
I have one straight table with 10 ranges (10 columns; like temperature 1, temperature 2, pressure 1 etc.) and for eache range i want to see the max temp. Min temp. and average temp in the same table.
A column can have only one total. If you want to show other totals you need to add more expression columns.
Or perhaps create another table that only shows the totals (min, max and avg) for each of the 10 ranges.
Goedemiddag Gysbert,
I gonna try it, let you know if it works.
Thanks.
Please find attached file. Hope this will help to you.
See attached. Don't ask about a better presentation 🙂