AnsweredAssumed Answered

How can I display summary information in a portal?

Question asked by juandent on Dec 1, 2017
Latest reply on Dec 1, 2017 by philmodjunk

Hi,

 

I have a StatementLines table with main fields like so:

 

Date, Concept, LocalAmount, CategoryName, ...

 

And summary fields that calculate the TotalLocalAmount per Category ... this forces me to sort the main table ocurrence by CategoryName. I can chart this easily (with some help!). The chart displays the CategoryNames as X-axis and the TotalLocalAmounts as Y-axis, and it is sorted so the higher TotalLocalAmounts appear first.

 

Thats fine, but there are many categories and the chart just becomes too unwieldy. So, I am looking how I can display only a certain percentage of the categories, or from a certain range of TotalLocalAmounts. Yet, I can't figure how because one cannot create a Find by specifying a calculated or summary field's contents.

 

So I thought I could create a portal with the summary fields of the main table or another table ocurrence of the main table united by a cartesian product, but it does not display summary fields - it only displays the records of the main table.

 

So, I am at a loss as to how to deal with this...

 

 

Would appreciate any help!!

 

Thanks,

Juan

Outcomes