Skip to Content
avatar image
Former Member

Reference column in two structure

Hi,

I need to display the data in following format

contractno contract value quotationno quotation value

The contract and quotation are coming from same DSO as both are 0document no and they are seprating using document type

if document type = G then it is contract and if B then it is quotation

To acheive this, i created the selection in query with document type for quotation in rows and quotation value in column

When i try to save query i am getting 0document_type used in both structure

I checked about help cells and reference cells, but i am not sure if this will solve my issue

Appreciate your input to fix the issue

Regards

Ben

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 08, 2014 at 03:40 PM

    Hi Ben,

    1 Create Structure in ROWS,

    2 New Selection->Doc_type (G)-->Description of new selection is contract

    3 New Selection->Doc_type (B)-->Description of new selection is quotation

    4 Place key fey figures in columns.

    Please try this and let me know.

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ben,

      No need to create a selection type with doc_type filter in keyfigure structure since you will already create two(2) selections in your ROW using the doc_type..Afterwards drag your keyfigures in the COLUMN..

      Just follow what Nanda said..

      Regards,

      Loed

  • Sep 09, 2014 at 03:51 AM

    Hi Ben,

    You can't use same infoobject for row and column structure..

    Try the suggestion of Nanda..

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded