Skip to main content
Solved

Grouping columns

Dennis1690
Vanguard
Forum|alt.badge.img+4

Context
I’m trying to create a grid that contains rows with prognosis, values and totals. Based on a contract-number. The idea is to be able to quickly gain insight into specific contracts prognosis, values and totals.

Example:

What do I want?

Group on afspraak, omschrijving and leveranciers (all belong to contract), each contract has 3 rows of prognosis (inkoopwaarde, prijswijziging and total) each with its corresponding months.

Datastructure:

Its all one table in 1NF (supplier list is a description and has no relation and is not intended to).

What did I try?

I’ve tried working with the group untill function in the subjects, however as soon as Im adding more groups (for omschrijving and leverancier) the grid changes to a triple hierarchy tree-like view. Thats not what I want. 

When is problem solved?

When I can make a grid in software factory that is like the example in context.
 

Any suggestion is welcome and appreciated. Thanks in advance.

Best answer by Mark Jongeling

Hi Dennis,

I’ve tried working with the group untill function in the subjects, however as soon as Im adding more groups (for omschrijving and leverancier) the grid changes to a triple hierarchy tree-like view. Thats not what I want. 

That is indeed the way it functions. However, you can create a calculated field* to concat these three fields like "123 - Description - Supplier”. Then it is only one column and you can use Goup until and only have one hierarchy treegroup. Would that suffice?

* = Calculated fields are stored in the database as column so the value does not need to be calcuated on the fly as expression column. Using calculated fields often gives you the best performance. Calculated fields are recalculated if any of the included columns are modified.

View original
Clear Skies
This topic has been closed for comments

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi Dennis,

I’ve tried working with the group untill function in the subjects, however as soon as Im adding more groups (for omschrijving and leverancier) the grid changes to a triple hierarchy tree-like view. Thats not what I want. 

That is indeed the way it functions. However, you can create a calculated field* to concat these three fields like "123 - Description - Supplier”. Then it is only one column and you can use Goup until and only have one hierarchy treegroup. Would that suffice?

* = Calculated fields are stored in the database as column so the value does not need to be calcuated on the fly as expression column. Using calculated fields often gives you the best performance. Calculated fields are recalculated if any of the included columns are modified.

"Wake me up before you low-code"
Dennis1690
Vanguard
Forum|alt.badge.img+4

Thanks for clarifying. 

Clear Skies
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings