Forum Discussion

S2861926's avatar
S2861926
Regular Visitor
4 years ago

How to correlate more rows in the same table with unique ID

Hi, in a table (SQL database) I have the double-entry bookkeeping (accounting movements) as shown in the attached figure:                           I want to correlate all the mo...
Need Help
NilR's avatar
NilR
Icon for Post Patron rankPost Patron
4 years ago

So doesn't have to be static you can make a dynamic table ,a portion of your current query/table  , something like this:

 

Select Distict Registration ID, Customer Name,

from Table

;

 

 

S2861926's avatar
S2861926
Regular Visitor
4 years ago

sorry but i can't understand what you mean ... could you be more specific?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi S2861926,

    I mean you can add a calculated column to store the customer that extract from each registration ID group.

    Then you can use this field to create a table visual with the above field and 'debit' and 'credit' fields.

    For the displayed value type, you can add a filter with the 'description' field to control which one is displayed on the visual.

    Regards,

    Xiaoxin Sheng